Delete by Primary Key

Anon

I am using PHP with MySql.

This statement does not work for me.

$result = mysql_query("delete from ksline1 where id = '$id'",$conn);

$id is my primary key
if I replace $id with any other field such as

$result = mysql_query("delete from ksline1 where company = '$company'",$conn);

it works.

Anon

remove your '1' and replace it with an integer. where id=1

Anon

I don't think I follow you. the value of $id is being sent to the script from another page. If I don't use $id and use $company or $date it works.

Anon

Your SQL is wrong. That's your problem man. if you have a string named id as a primary key, your tables are definatly screwed up beyond repair.

Anon

I did not see id as a reserved word in the documentation. Why am I screwed.

Anon

There is nothing wrong with your query, Tom is confused as evidenced by his first post which quoted something you did not have in your original post.

Two things:

1) Are you sure the value contained in $id is valid?

2) If the id column is numeric, remove the quotes as they aren't necessary and can be problematic should the $id variable contain some whitespace. This can happen if the $id variable was set in a form as all form variables are strings and not numeric, even if they contain only numeric data. For example, if the variable $id was set using a form, it could conceivably have the value ' 1' when what you want is '1'. By containing it in quotes in the query you would be saying "delete from ksline1 where id=' 1' which wouldn't match to the integer value 1. By removing the quotes you solve this problem as the whitespace doesn't matter if it isn't contained in quotes.