error when trying to delete a record

["Ross" <ross@xxxxxxxxxxxxx>]

I dunno if my text book is out of date or I have made a syntax error but I 
am trying to delete a record with


 $query= "DELETE FROM sheet1 WHERE id=$id";


 $result= mysql_query($query);
  if($result){
  echo "it was deleted";
 }
 else
 echo mysql_error();
 }


and I get the followign sql 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 '' at line 1 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php