Delete Records from MySQL

[Anon]

I'm trying to delete records from a MySQL database and everything says it was deleted but the actual record is unchanged. Here's my code can anyone tell me whats wrong with it?

Thanks

<?
$db_name = "firstcitymall_com";

$table_name = "business";

$connection = @mysql_connect("localhost", "database", "password") or die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql = "DELETE $table_name WHERE id = '$id'";

$display_block = "

  <br>
  <h2 align=center><font color=\"#102942\">Record #$id Successfully Deleted</font></h2>

";

?>

[jordan]

Two problems here. First, you don't actually execute a MySQL query. At least, I don't see a query being executed anywhere. Second, your DELETE syntax is wrong. The basic syntax goes "DELETE FROM table WHERE condition;" Check the manual -- doing so to begin with would've saved you a lot of trouble.

[Anon]

Couple of things..

For one, you are outputting the record being deleted successfully before you even execute the delete command.

Try this:
$sql = "delete from $table_name where id = $id";

$result = mysql_query($sql);

if ($result) {
print("h2 align=center>Record #$id Successfully Deleted</h2>");
} else {
print("h2 align=center>Record #$id was not deleted successfully</h2>");
}

[Anon]

Thanks tek! that got it.