MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Sime Date:March 15 2003 1:20pm
Subject:Re: Updat not Updating
View as plain text  
Andrew wrote:
> can you explain how I would do this tracking?
>
> My code looks exactly like this:
>
> mysql_connect("$DBHost","$DBUser","$DBPass");
> 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'");
> $result = mysql_query($query, $connection) or die("Error with query:
> ".mysql_error()."");

Hi Andrew,

Try building the query to a variable first, then output the variable to see
if what MySQL is receiving is what you expected..

eg,
$querystring="select * from mytable;";
echo("\n\n$querystring\n\n");
mysql_query($querystring);

will output..
select * from mytable;

You can check the syntax of the command this way.

S.

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