View Single Post
Old January 30th, 2005, 07:33 AM   #1 (permalink)
sail247
Junior Member
Verified Customer
 
Join Date: Jan 2005
Posts: 5
Error in SQL syntax

Hello,

I am recieving error messages from my classified ads when some people try to post to them, but other times it works ok. This was installed less than two weeks ago. Below is a copy of one of the error messages.

Can you help me? Thanks.

Lonny
http://sail247.com/classified

~~~~~~~~~~~~~~
An error was encountered during execution of the query:


INSERT INTO class_products (id,user,userid,cat,date,title,description,keywords,bigimage,bigimage2,bigimage3,approved,watermarked,ipaddress)
values(NULL,'zyzzos', 4, , 1107029050, '42\' STEEL BLUE WATER CRUISER', '', '', 'IM000222.jpg', '', '',
1, 'no', '152.163.100.198')


The query returned with an errorcode of:


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 ' 1107029050, '42\' STEEL BLUE WATER CRUISER', '', '', 'IM000222
sail247 is offline   Reply With Quote