MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Andrew Date:March 14 2003 6:49pm
Subject:RE: Updat not Updating
View as plain text  
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:paul@stripped]
>Sent: 14 March 2003 18:27
>To: andrew@stripped; cTpaXo
>Cc: mysql@stripped
>Subject: RE: Updat not Updating
>
>
>

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