On Tue, 2002-09-03 at 16:31, Matthias Trevarthan wrote:
> 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:
>
> '>
This prompt indicates y
Thanks everyone!
I see that I need double quotes now.
I received about 12 different personal emails from various people with exactly
the same answer. Thanks again!
On Tuesday 03 September 2002 10:31, Matthias Trevarthan wrote:
> Howdy,
>
> I'm trying to perform an update on a php poll table.
>
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 t
You need to escape the ' mark in your string. The query should be:
update vbooth_data set optionText='Not at all, I''m waiting for the
other shoe to drop' where (pollID=34 AND voteID=3);
Note the '' within the string: the first tick escapes the second one.
If you're more comfortable with C-styl
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="No
Hi,
You should escape quotes within strings:
Matthias Trevarthan wrote:
> Howdy,
>
> I'm trying to perform an update on a php poll table.
>
> Here is the table description:
>
> mysql> describe vbooth_data;
> +-+--+--+-+-+---+
> | Field | Type
