Howdy Matthias, update vbooth_data set optionText='Not at all, I'm waiting for the other shoe to drop' where (pollID='34' AND voteID='3');
When I hit Enter, it gives me this prompt: '> Two things: 1 (the >) is because it is waiting for the end of the string - you have an apostrophe opening the optionText string, then another one to 'end' it before WHERE, but there's a problem with the "I'm" apostrophe four words into the string! 2 both columns in the WHERE clause are integers, so neither value needs to be quoted. Regards, =dn List bait: SQL --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php