""Jay Blanchard"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] [snip] $query= "DELETE FROM sheet1 WHERE id=$id";
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 [/snip] try... $query= "DELETE FROM sheet1 WHERE id = '".$id."' "; Note the single quotes around conditional data. Imagine if $id = 1 and you did your original query, it would read... $query= "DELETE FROM sheet1 WHERE id=1"; Which is where id = TRUE. You could end up deleting all of the records in the database. --- Is the above statement true when the id field is numeric (which it surely is in this case)? I get the expected results (in mySQL) when using statements like SELECT name FROM table WHERE id=1 with no single quotes round it. Putting quotes round integer values is counter-intuitive - is it necessary in some cases? --- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
