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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
