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

Reply via email to