List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 14 2003 6:46pm
Subject:RE: Updat not Updating
View as plain text  
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
Thread
Updat not UpdatingAndrew14 Mar
  • Re: Updat not UpdatingPaul DuBois14 Mar
  • Re: Updat not Updatingnobody14 Mar
    • RE: Updat not UpdatingAndrew14 Mar
      • Re[2]: Updat not Updatingnobody14 Mar
      • RE: Updat not UpdatingPaul DuBois14 Mar
        • RE: Updat not UpdatingAndrew14 Mar
          • RE: Updat not UpdatingPaul DuBois14 Mar
          • Re: Updat not UpdatingBrian McCain14 Mar
            • RE: Updat not UpdatingAndrew15 Mar
              • Re: Updat not UpdatingSime15 Mar
                • Re: Updat not UpdatingDon Read16 Mar