lak Posted November 11, 2007 Share Posted November 11, 2007 Hello,I uploaded worked file, AND CHECKED IT UP.I got error as follow: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 '','12','4545645657','7867897987','REE RERET RRE','123','56','325')' at line 2Pls give suggestion as soon as possible Link to comment Share on other sites More sharing options...
Synook Posted November 11, 2007 Share Posted November 11, 2007 Pls give suggestion as soon as possibleUmm... post the whole query? It is hard to tell what the error is as it is usually the part of the query directly before the quoted section that causes the error. Link to comment Share on other sites More sharing options...
ScottR Posted November 11, 2007 Share Posted November 11, 2007 I'd be one bad mutha if I could debug that error with that info! Link to comment Share on other sites More sharing options...
lak Posted November 12, 2007 Author Share Posted November 12, 2007 Umm... post the whole query? It is hard to tell what the error is as it is usually the part of the query directly before the quoted section that causes the error.before that i uploaded the same file, there was no error and worked fine. i have done some corrections and uploaded , but it was telling "my sql syntax error". Then i got one idea, i downloaded the file which was worked when uploaded first time, and done correction and uploaded again, its working fine. why its like this?. what is meant by,"my sql syntax error, and line2, line3.Can you? Link to comment Share on other sites More sharing options...
Synook Posted November 12, 2007 Share Posted November 12, 2007 A syntax error is an error with the way your query is constructed (like bad English but with SQL ). So, something with your query is wrong. It was probably some of the variable data that was causing the error. Link to comment Share on other sites More sharing options...
lak Posted November 12, 2007 Author Share Posted November 12, 2007 A syntax error is an error with the way your query is constructed (like bad English but with SQL ). So, something with your query is wrong. It was probably some of the variable data that was causing the error.thank you Link to comment Share on other sites More sharing options...
justsomeguy Posted November 13, 2007 Share Posted November 13, 2007 like bad English but with SQLlolSince the error message starts with a quote, most likely you have 2 quotes closing a string, or an un-escaped quote in the string. Like Synook said, it's hard to tell without seeing the entire query. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.