Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #2289

Re: insert query error

Show all headers | View raw

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@attglobal.net
==================

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

insert query error anu <anucherkuri@gmail.com> - 2011-06-21 07:43 -0700
  Re: insert query error Luuk <Luuk@invalid.lan> - 2011-06-21 16:49 +0200
  Re: insert query error "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2011-06-21 18:54 +0200
  Re: insert query error Bill B <me@privacy.net> - 2011-06-21 13:19 -0400
  Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-21 15:48 -0400
    Re: insert query error Bill B <me@privacy.net> - 2011-06-21 15:58 -0400
      Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-21 22:15 -0400
    Re: insert query error Jonathan Stein <jstein@image.dk> - 2011-06-22 12:04 +0200
      Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-22 06:38 -0400
        Re: insert query error Jonathan Stein <jstein@image.dk> - 2011-06-22 17:03 +0200
          Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-22 15:34 +0000
            Re: insert query error Jonathan Stein <jstein@image.dk> - 2011-06-22 21:54 +0200
              Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-22 21:44 +0000
          Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-22 12:08 -0400
            Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-22 21:46 +0000
              Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-22 23:23 -0400
                Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 11:38 +0000
                Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 08:41 -0400
                Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 13:34 +0000
                Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 12:45 -0400
                Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 17:51 +0000
                Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 15:04 -0400
                Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 20:32 +0000
                Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 19:23 -0400
                Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 23:33 +0000
                Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 22:23 -0400
                Re: insert query error Luuk <Luuk@invalid.lan> - 2011-06-23 20:39 +0200

csiph-web