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
[EMAIL PROTECTED]

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

Reply via email to