[SOLVED] Invalid Query - SQL Syntax.... was working before conversion

[croix]

Hello,

I am getting SQL syntax error on a page that I am in the process of converting from Access to MySQL.

 

Here is the error:

Invalid query: 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 '* FROM customers WHERE customerID = 727' at line 1 Whole query: DELETE * FROM customers WHERE customerID = 727

 

I checked out the MySQL manual, but I don't see anything wrong with my syntax.... maybe Im looking in the wrong place.

 

 

 

******EDIT******

 

I was looking at the wrong documentation...

 

The proper (and working) syntax was DELETE FROM customers WHERE ....

[Wildbug]

Remove the asterisk.  No columns are used in the DELETE command as the entire row is always deleted.

 

DELETE FROM customers WHERE customerID = $customerID;