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 ; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
