MySQL Forums
Forum List  »  Newbie

error #1064 - help urgently needed
Posted by: tomtom striessnig
Date: April 09, 2005 07:17PM

Hello at all! I'm a newbie and i need to code a small php-mysql project for school, but i got a big big problem... i tried to figure out a solution for mire than 6 hours now. maybe you can help...

this is the mysql-query

UPDATE IGNORE alben SET ahp='http://www.insaneclownposse.com/';, abildkl='../pics/icp1kl.jpg', abildgr='../pics/icp1.jpg', ainter='Insane Clown Posse', atitel='The Amazing Jeckel Brothers', ajahr='1999', agenre='Progressive Rock', apreis='9.99', adetail='Diese CD erschien 1999 im Universal Plattenlabel. Sie enthält 17 geniale Songs von den bekannten Schockrockern...', WHERE anr=0;


and this is what mysql says:
#1064 - 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 'WHERE anr=0' at line 1


hope you can help, kind regards, thomas!

Options: ReplyQuote


Subject
Written By
Posted
error #1064 - help urgently needed
April 09, 2005 07:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.