McTedo
9-8-09, 01:17 PM
Hullo Guys,
Not sure why this UPDATE statement is only changing the first field in the row (title) and not the rest. Some help would be much appreciated!
UPDATE customer
SET title = "Mr",
forname = "Bob J",
surname = "Marley",
address1 = "A House",
town = "A Lane",
city = "A Town",
county = "",
postcode = "PST CDE",
homephone = "01234 567890",
mobilephone = "",
workphone = "",
email = "email@me.com",
email2 = "email2@me.com",
offers = 0
WHERE cid = 19020;
Thanks!
Not sure why this UPDATE statement is only changing the first field in the row (title) and not the rest. Some help would be much appreciated!
UPDATE customer
SET title = "Mr",
forname = "Bob J",
surname = "Marley",
address1 = "A House",
town = "A Lane",
city = "A Town",
county = "",
postcode = "PST CDE",
homephone = "01234 567890",
mobilephone = "",
workphone = "",
email = "email@me.com",
email2 = "email2@me.com",
offers = 0
WHERE cid = 19020;
Thanks!