Can anyone tell me why this is not updating records for this table?
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'");
Andrew
We cannot, but MySQL and PHP can.
1) Check the return values of the function calls to make sure they work. As written, you have no way of knowing.
2) When an error occurs, print the value of mysql_error() to see what the error is.
-- Paul DuBois, [EMAIL PROTECTED] http://www.kitebird.com/ sql, query
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
