[RESOLVED] delete multiple where

[acemo]

I am trying to delete a row in the mysql database where the username and name_site have to be correct.

current code:

        include "inc.mysql_connect.php";
        $query = "DELETE FROM 'personal_bookmarks' WHERE username='" . $_SESSION['username'] . "' AND name_site='" . $_POST['name_remove_site'] . "'";
        $result = mysql_query($result) or die(mysql_error()); 

This results into a nice syntax error.

Could anyone tell me what i did wrong?

[gayatri]

try using addslashes and
for
$result = mysql_query($result) or die(mysql_error());
make
$result = mysql_query($query) or die(mysql_error());

[acemo]

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''personal_bookmarks' WHERE username='username' AND name_site='beef

getting this error after replacing $result for $query, wich was kinda a dumb mistake >.<

[gayatri]

i guess u need not use single quotes for table name, i mean quotes r not needed, try with that removed, else with addslashes(most practical solution)
\'table name'\ like this

[acemo]

removing the single quote's helped, thanks