I have an idea why this is but not 100% there is a diffeence in order between
query and Table the ItemID comes after the Ctelephone column in the DB. So
presumably this is the problem, but I realy haven't the foggiest why.
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'");
Andrew
>-----Original Message-----
>From: Paul DuBois [mailto:[EMAIL PROTECTED]
>Sent: 14 March 2003 18:27
>To: [EMAIL PROTECTED]; cTpaXo
>Cc: [EMAIL PROTECTED]
>Subject: RE: Updat not Updating
>
>
>
---------------------------------------------------------------------
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
