Hi!
I'm having a problem with the UPDATE syntax for MySQL
(aside - I hate products that tell me I have a syntax problem, but
don't tell me what it is - and then suggest that I go RTFM which is
equally uninformative:-()
I'm replacing the entire set of fields, WHERE a condition exists for
some of the fields, ie
UPDATE table_name SET field1 = ' value1', field2 = ' value2', field3
= ' value3, field4 = ' value4' WHERE field1 = ' value1' AND field2 =
' value2';
MySQL says that I have error 1064 'near WHERE field1 = ' value1' AND
field2 = ' value2'
but it doesn't say what therror is (grrr!)
My questions:
My question is what is the appropriate way to expand the syntactic
construct of "where_condition", which is not otherwise explained!
Help!
Tony
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.0/1218 - Release Date: 1/10/2008 1:32 PM
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
