| Re: insert query error [message #174612 is a reply to message #174605] |
Wed, 22 June 2011 10:04   |
Jonathan Stein
Messages: 43
Registered: September 2010
Karma:
|
Member |
|
|
Den 21-06-2011 21:48, Jerry Stuckle skrev:
>> Could not successfully run insert 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 ''','','','','','','','','','','')'
>> at line 2
>
> You have a MySQL message - ask in a MySQL newsgroup, such as
> comp.databases.mysql.
Why bother a MySQL group? - They won't be able to help from the message.
The solution is to:
1. Add PHP code to print the SQL statement. (PHP task)
2. Realize where the missing or extra ' is. (SQL task - but after step
1, the poster probably won't need help for this step)
3. Fix the PHP code to generate a valid statement. (PHP task)
> This isn't a PHP problem.
We could discuss this, but the solution involves more PHP than SQL, so
this group is fine for the question. The poster should just have
included the code generating the SQL query.
Regards
Jonathan
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]