[SOLVED] mysql delete record

[daveh33]

when I run this code below it doesn't delete the record or display any error message

 

$id = $_GET['id'];
include("../dbconnect.php");
mysql_query("DELETE FROM promotions WHERE id='$id'") or die(mysql_error()); 

 

 

Such a simple thing to do but I don't no why it doesn't work  ???

[pocobueno1388]

You $id var is probably null.

 

Do this

echo "DELETE FROM promotions WHERE id='$id'";

 

Post what it gives you.

[daveh33]

Yes you were right it displays: -

 

DELETE FROM promotions WHERE id=''

 

I found the problem - I changed the url and didnt include &id=$id

 

Thanks for your help