delete statement not working

[tolkienarda]

hi all
i have a loop that decides if a row should be deleted. i know i am getting into my if statement and that the variable that stores the id is correct but the delete statement wont work can someone look and see what dumb mistake i made

[PHP]
$a=mysql_query( "DELETE FROM 'calendar' WHERE 'id'='$row2[0]'");
[/PHP]

i know that $row2[0] = the id cause i have an echo statement under that but for some reason my stuff never gets deleted from the database

eric

[tolkienarda]

hi all
i have a loop that decides if a row should be deleted. i know i am getting into my if statement and that the variable that stores the id is correct but the delete statement wont work can someone look and see what dumb mistake i made

[PHP]
$a=mysql_query( "DELETE FROM 'calendar' WHERE 'id'='$row2[0]'");
[/PHP]

i know that $row2[0] = the id cause i have an echo statement under that but for some reason my stuff never gets deleted from the database

eric

my bad i needed to take the quotes out around calendar

[Atli]

You don't need the quotes around the id column either.

[tolkienarda]

ok thanks

eric