Matthias, MySQL is letting you know that you have an unterminated string with the apostrophe. You'll have to either use double quotes to contain the string "Not at all, I'm waiting for the other shoe to drop", or escape the apostrophe in the word "I'm".
i.e. UPDATE vbooth_data SET optionText="Not at all, I'm waiting for the other shoe to drop" WHERE (pollID='34' AND voteID='3'); Or UPDATE vbooth_data SET optionText='Not at all, I\'m waiting for the other shoe to drop' WHERE (pollID='34' AND voteID='3'); HTH, Bryant Hester Juxtapose, inc. -----Original Message----- From: Matthias Trevarthan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: UPDATE syntax dummy question... Howdy, I'm trying to perform an update on a php poll table. Here is the table description: mysql> describe vbooth_data; +-------------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+-------+ | pollID | int(11) | | | 0 | | | optionText | char(50) | | | | | | optionCount | int(11) | | | 0 | | | voteID | int(11) | | | 0 | | +-------------+----------+------+-----+---------+-------+ 4 rows in set (0.00 sec) And here is my update query: 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: '> And nothing I input will do anything. I end up having to exit with CTRL-C or CTRL-D. I know this is probably a simple syntax issue, but what am I doing wrong?? And what is mysql looking for with that '> prompt? Thanks! Matthias --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
