List:General Discussion« Previous MessageNext Message »
From:Andrew Maynes Date:February 26 2003 5:45pm
Subject:Table Update
View as plain text  
problably a silly question but if I am updating a table in a MySQL DB with a
table structure like this:

 TABLE xxx
  ItemSKU
  ItemName
  ItemDescription
  PostCode
  Category
  CityID
  CTelephone
  ItemID
  Cfax
  Cemail
  Caddress
  CTown
  Cwww
  PRIMARY KEY (ItemID)

and the update query is 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'");


is there any reason why it would not work???

Cheers
Andrew

Thread
Table UpdateAndrew Maynes26 Feb
  • RE: Table UpdateDon Read26 Feb