| Re: insert query error [message #174614 is a reply to message #174612] |
Wed, 22 June 2011 10:38   |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
|
Senior Member |
|
|
On 6/22/2011 6:04 AM, Jonathan Stein wrote:
> 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.
>
Because they will be able to help from the message. And they will give
a GOOD answer.
> 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
The problem is MySQL. Ask in the correct newsgroup, and you'll get a
good answer. Ask in the wrong newsgroup and you'll get a crap answer -
like the above.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]