Ross wrote:
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
echo out $id and/or your query to ensure it is what you think it is.
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@xxxxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php