Re: MySQL update statement problem

You need to separate the SET arguments with commas, not ANDs... It's really doing something like this: UPDATE shop_customer SET eu_vat_number = ("SK1234567890" AND vat_amount = 0 AND total_amount = 8.4925) WHERE customer_id = 7 AND hash="dcd5e751" ("SK1234567890" AND vat_amount = 0 AND total_amount = 8.4925) evaluates to false (0) , so that's what gets set. Kevin Davies - Bonhurst Consulting wrote:

Hi, Apologies if this isn't the right place to ask - but I'm banging my head against the wall with this one! I'm trying to update a record in the table (creation script below) using the following SQL statement: UPDATE shop_customer SET eu_vat_number = "SK1234567890" AND vat_amount = 0 AND total_amount = 8.4925 WHERE customer_id = 7 AND hash="dcd5e751" Before running the query the value for eu_vat_number is 'null', vat_amount is 0.085 and total_amount = 8.5775. After I run the query (mysql_affected_rows = 1) the values for vat_amount and total_amount remain the same, but vat_number is changed to 0. I've been looking at this most of the afternoon, and it's probably something really simple but I just can't see it... Any ideas? Thanks in advance for your help... Cheers, Kev -- Server version: 3.23.58 -- PHP Version: 4.3.10 CREATE TABLE shop_customer ( customer_id int(11) NOT NULL auto_increment, hash varchar(8) NOT NULL default '', first_name varchar(255) NOT NULL default '', last_name varchar(255) NOT NULL default '', email_address varchar(255) NOT NULL default '', member_id int(11) default NULL, address1 varchar(255) default NULL, address2 varchar(255) default NULL, town varchar(255) default NULL, county varchar(255) default NULL, postcode varchar(255) default NULL, country int(11) NOT NULL default '0', eu_vat_number varchar(15) default NULL, total_items int(11) default '0', net_amount float default '0', vat_amount float default '0', shipping_amount float default '0', total_amount float default '0', added datetime NOT NULL default '0000-00-00 00:00:00', payment_received datetime default NULL, PRIMARY KEY (customer_id) ) TYPE=MyISAM AUTO_INCREMENT=8 ;