Hi,
Once I pressed submit to delete I want to echo, "record deleted".
It is not displaying now, can someone tell me why....It code it at the bottom.
Thanks
[PHP]
<?PHP
header( "cache-control: no-cache, must-revalidtae" );
header( "Pragme: no-cache" );
?>
<form action="<?php echo( $self ); ?>" method="post">
<select name="table">
<option value="a" selected="selected">A</option>
<option value="b">B</option>
<option value="c">C</option>
<option value="d">D</option>
<option value="e">E</option>
<option value="f">F</option>
<option value="g">G</option>
<option value="h">H</option>
<option value="i">I</option>
<option value="j">J</option>
<option value="k">K</option>
<option value="l">L</option>
<option value="m">M</option>
<option value="n">N</option>
<option value="o">O</option>
<option value="p">P</option>
<option value="q">Q</option>
<option value="r">R</option>
<option value="s">S</option>
<option value="t">T</option>
<option value="v">V</option>
<option value="w">W</option>
<option value="x">X</option>
<option value="y">Y</option>
<option value="z">Z</option>
</select>
<label></label>
<label>
<input name="biz" type="text" id="biz">
</label>
<br>
<input type="submit" value="submit">
</form>
<?php
$biz = $_POST['biz'];
$self = $_SERVER['PHP_SELF'];
$table = $_POST['table'];
$self = $_SERVER['PHP_SELF'];
$submit = $_POST['submit'];
$con = mysql_connect("localhost", "******", "*****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}mysql_select_db("*********", $con);
mysql_query("DELETE FROM $table WHERE business_name='$biz'");mysql_close($con);
if (isset($_POST['submit'])) {
$submit = "Record Deleted";
echo ("$submit");
}
?>
[/PHP]