problably a silly question but if I am updating a table in a MySQL DB with a
table structure like this:
TABLE xxx
ItemSKU
ItemName
ItemDescription
PostCode
Category
CityID
CTelephone
ItemID
Cfax
Cemail
Caddress
CTown
Cwww
PRIMARY KEY (ItemID)
and the update query is this:
mysql_connect("$DBHost","$DBUser","$DBPass");
mysql("$DBName","UPDATE items
SET ItemSKU='$ItemSKU',
ItemName='$ItemName',
ItemDescription='$ItemDescription',
PostCode='$PostCode',
Category='$Category',
CityID='$CityID'
CTelephone='$CTelephone'
Cfax='$Cfax'
Cemail='$Cemail'
Caddress='$Caddress'
Cfax='$CTown'
Cwww='$Cwww'
WHERE ItemID='$ItemID'");
is there any reason why it would not work???
Cheers
Andrew