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:paul@stripped]
>>Sent: 14 March 2003 18:27
>>To: andrew@stripped; cTpaXo
>>Cc: mysql@stripped
>>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, paul@stripped
http://www.kitebird.com/
sql, query
