Re: error when trying to delete a record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux