Echo after delete

[webandwe]

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="selec ted">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_d b("*********" , $con);

mysql_query("DE LETE FROM $table WHERE business_name=' $biz'");mysql_c lose($con);

if (isset($_POST['submit'])) {
$submit = "Record Deleted";

echo ("$submit");
}

?>

[/PHP]

[mwasif]

Change the submit button to
<input type="submit" value="submit" name="submit">

OR

[PHP]<?php
// page is submitted
if (isset($_POST['submit'])) {
{
$biz = $_POST['biz'];
$self = $_SERVER['PHP_SELF'];
$table = $_POST['table'];
$self = $_SERVER['PHP_SELF'];
$submit = $_POST['submit']; // Why you are doing this?


$con = mysql_connect(" localhost", "******", "*****");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db ("*********" , $con);

if(mysql_query( "DELETE FROM $table WHERE business_name=' $biz'"))
{
$submit = "Record Deleted";
echo ("$submit");
}

mysql_close($co n);
}
?>[/PHP]

consider using mysql_real_esca pe_string() (www.php.net/mysql_real_esca pe_string) like

[PHP]$biz = mysql_real_esca pe_string($_POS T['biz']);[/PHP]

[webandwe]

thanks, it is working now