Posted by JDS on 06/30/06 15:41

On Fri, 30 Jun 2006 07:56:15 -0700, schaeffer.kyle wrote:

> I'm not really sure where the synatx error could be. Any help would be
> appreciated.

Try the SQL statement on the MySQL command line. Do you get an error?

Don't know how to use the MySQL prompt? Try PHPMyAdmin, MySQL
Administrator, or other MySQL admin tool.

The debugging process here should be as follows:

1) Verify that the SQL statement that you posted is, in fact, the SQL
statement that is being sent to the server.

2) Try SQL statement in MySQL directly -- via mysql> prompt, for example.

3) Break SQL statement into several lines and retry it in mysql> prompt.
Having several lines will help narrow down the location of the error.

later...

--
JDS

[Back to original message]