PDA

View Full Version : mysql syntax error


AN-net
03-14-2004, 03:19 AM
got this error don't know wuts wrong:

Invalid SQL: UPDATE gallery SET image_name='bacon1,image_url='http://www.animationation.net/community/images/misc/banner.jpg',image_des='testing description',image_actve='1',usethread='0',image_v iews='0',image_totalrating='0',image_totalvotes='0 ' WHERE image_id='1'
mysql 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 'http://www.animationation.net/community/images/misc/banner.jpg'

mysql error number: 1064

MindTrix
03-14-2004, 10:04 AM
Is there sposed to be a ' after bacon1 ???

AN-net
03-14-2004, 02:42 PM
oh yeah, woops thanks mindtrix