Thanks for responding! :) "UPDATE sites SET start_date = '$MySQLDate', domain = '$host_edit', host_plan = '$host_plan_edit', ssl = '$ssl_edit', fp_ext = '$fp_ext_edit', username = '$username_edit', password = '$password_edit', fp_password = '$fp_password_edit', cust_comments = '$cust_comments_edit', customer_id = '$customer_id_edit', shared = '$shared_edit', ip_address = '$ip_address_edit', server_name = '$server_name_edit', site_id = '$site_id_edit', host_price = '$host_price_edit' WHERE domain = '$domainhosted'"
-Mike > -----Original Message----- > From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 8:21 AM > To: [EMAIL PROTECTED] > Subject: Re: Going from 3.23 to 4 - sql statement errors > > > "Mike R" <[EMAIL PROTECTED]> wrote: > > > > Sorry if I posted this twice - I had some email issues yesterday, and I > > didn't know if this made it to the list: > > > > > > I am using php with mysql, and after moving my tables to a new > server, I am > > suddenly getting this error: > > > > Query failed: You have an error in your SQL syntax. Check the > manual that > > corresponds to your MySQL server version for the right syntax > to use near > > 'this = 'No', fp_ext = 'No', username = 'jreft', password = 'sna > > > > I find this rather generic - does anyone have any suggestions > as to where I > > can start to figure out why MySQL is erroring out a statement > that worked > > fine with 3.23, but doesn't with 4? The fields are varchar types, a few > > with default values. Considering there isn't anything that unusual, I'm > > having a hard time figuring this one out! > > > > Mike, provide the whole query. > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
