At 18:49 +0000 3/14/03, Andrew wrote:
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', <-- no comma here!
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
>
See note embedded in query above. To spot these things more easily,
you might consider assigning the query to a variable. Then you can pass
the variable to the mysql() function, and also print it later if an
error occurs.
--
Paul DuBois, [EMAIL PROTECTED]
http://www.kitebird.com/
sql, query
---------------------------------------------------------------------
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