MySQL the right syntax to use near at line 1 error

Question

hello i have a run a query using php it give error   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 1  but when i echo the query and run manually using sqlyog software it runs fine  can anyone say whats the problem on here this is my generated query  INSERT INTO wp bp activity                           user id               component                type                 action                content               primary link               item id               secondary item id               date recorded               hide sitewide               mptt left               mptt right                             VALUES               1  activity   activity update    lt a title  admin  href  http   brandnewmusicreleases com social-network members admin   gt admin lt  a gt  posted an update    lt a title  242925 1  href  http   brandnewmusicreleases com social-network wp-content uploads 242925 1 jpg  class  buddyboss-pics-picture-link  gt 242925 1 lt  a gt    http   brandnewmusicreleases com social-network members admin            2012-06-22 12 39 07  0 0 0                  and here is my php code   qr2  INSERT INTO wp bp activity                           user id               component                type                 action                content               primary link               item id               secondary item id               date recorded               hide sitewide               mptt left               mptt right                             VALUES                cid  activity                 activity update                  lt a href   http   brandnewmusicreleases com social-network members  name    title    name   gt  name lt  a gt  posted an update                  lt a class   buddyboss-pics-picture-link   href   http   brandnewmusicreleases com social-network wp-content uploads  imgname   title    ionlyname   gt  ionlyname lt  a gt                  http   brandnewmusicreleases com social-network members  name                                                       time                0               0               0                    after edited  echo  qr2  INSERT INTO wp bp activity  user id component  type   action  content primary link item id secondary item id date recorded hide sitewide mptt left mptt right  VALUES  cid  activity   activity update    lt a href   http   brandnewmusicreleases com social-network members  name    title    name   gt  name lt  a gt  posted an update    lt a class   buddyboss-pics-picture-link   href   http   brandnewmusicreleases com social-network wp-content uploads  imgname   title    ionlyname   gt  ionlyname lt  a gt    http   brandnewmusicreleases com social-network members  name           time  0 0 0     mysql query  qr2  or die mysql error

User · Answer

INSERT INTO wp bp activity                           user id               component                type                 action                content               primary link               item id               secondary item id               date recorded               hide sitewide               mptt left               mptt right                             VALUES               1  activity   activity update    lt a title  admin  href  http   brandnewmusicreleases com social-network members admin   gt admin lt  a gt  posted an update    lt a title  242925 1  href  http   brandnewmusicreleases com social-network wp-content uploads 242925 1 jpg  class  buddyboss-pics-picture-link  gt 242925 1 lt  a gt    http   brandnewmusicreleases com social-network members admin            2012-06-22 12 39 07  0 0 0

User · Answer

the problem is because you have got the query over multiple lines using the     that PHP is actually sending all the white spaces in to MySQL which is causing it to error out   Either put it on one line or append on each line  o   Sqlyog must be trimming white spaces on each line which explains why its working   Example    qr2  INSERT INTO wp bp activity                     user id    this stuff component        is        type        a          action      problem   content               primary link               item id

[php] MySQL the right syntax to use near '' at line 1 error

Examples related to php

Examples related to mysql