MySQL update statement problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux