SQL: delete a row ?

[Pellefant]

Please help....

$Query = "UPDATE reviews WHERE id=$id"; (working fine)

Instead of update I now want to delete the whole row.

(PHP+mySQL)

[YappyDog]

Try:

$Query = "DELETE reviews WHERE id=$id";

[Pellefant]

Hi! 🙂

Didn't work. 🙁

I have also tried:

$Query = "DELETE * reviews WHERE id=$id";

Error: 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 ' reviews WHERE id=1' at line 1 in query: DELETE reviews WHERE id=1

[rw22]

Isn't it

DELETE * FROM reviews WHERE id=$id

[Pellefant]

Hi!

Thanks for all help.

I strongly belive I make something else wrong in the code now 🙁

<?
$id = $_GET['id']; 
$Link = mysql_connect("localhost", "user_user", "password"); 
mysql_select_db("user_tonydb", $Link); 

$Query = "DELETE * FROM reviews WHERE id=$id";

$Result = mysql_query($Query) or die("Error: ".mysql_error()." in query: ".$Query);
?>

Gets me the error:

Error: 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 ' FROM reviews WHERE id=1' at line 1 in query: DELETE FROM reviews WHERE id=1

But this Update SQL question works fine:

<?
$id = $_GET['id']; 
$Link = mysql_connect("localhost", "user_user", "password"); 
mysql_select_db("user_tonydb", $Link); 

$Query = "UPDATE reviews SET approved=1 WHERE id=$id"; 

$Result = mysql_query($Query) or die("Error: ".mysql_error()." in query: ".$Query);
?>

Strange.... 😕

[Pellefant]

Hm...can it be that id is a reserved PHP word?

But I have tried [id] also now (That's the way with reserved word with Access I know, is it the same with mySQL please?)

[Pellefant]

This solved it 🙂

$Query = "DELETE FROM reviews WHERE `id`=$id";