Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    MYSQL




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 'orange' WHERE `ID` = '11128'' At Line 1


I am getting this error message everytime I run my php script....
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 'orange' WHERE `ID` = '11128'' at line 1

It seems that there is a limit on the where syntax. I don't know how to fix it, and it's a very big problem for me.

My task is to insert 1million values into mysql table with a php foreach loop. If I insert aprox. 10.000 values, this error don't come, but any numer over will give my mysql error.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread

    Copyright © 2005-08 www.BigResource.com, All rights reserved