Can't delete record from table

Anon

This is wierd because my code is written correctly and yet i am i am getting Couldn't execute query when i try to delete a record. I have the same code (execpt for the query functions) to modify a record and it works like a charm. Here is my code:

if (!$customer_id) {
header("Location:http://216.122.218.121/select_customer_to_delete.php");
exit;
}

$db_name = "test";
$table_name = "my_customers";

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

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

$sql = "DELETE FROM $table_name WHERE customer_id = \"$customer_id\"";

$result = @($sql,$connection) or die("Couldn't execute query.");

$display_block ="
<p><strong>The record has been successfully deleted
";
?>
<? echo "$display_block"; ?>

thanks for any help

amcgrath

my guess would be the \" in the query variable. If custoemr_id is an integer, don't put any quotes, if it isn't you souhld be able to use singe quotes instead... i dunno... I don't use mysql.

Anon

i tried taking off the quotes, using single quotes and it still doesnt work. customer_id is an int data type that is primary key and auto increment

amcgrath

Do me a favor and output the $sql value within die("Couldn't execute query.") I want to see the actual query, and can u then run this query directly into the database to see what happens?

Anon

the $sql value is

DELETE FROM customer_table WHERE customer_id = "33"

Anon

remove \"
right this...

$sql = "DELETE FROM $table_name WHERE customer_id = $customer_id";

Anon

already tried that, and this is my sql value then:

DELETE FROM customer_table WHERE customer_id = 34

Anon

i got it. the code was fine, my permissions were not set up in mysql for to delete. Thanks for your help though guys.