The best way would be to design the table so that it had an item_id field that was an auto-incremented integer and not updateable. It shouldn't be too late to add such a field, then it can be passed from the form as a hidden field (as I assume you're currently doing with $oldItemCode).
Tim Ward http://www.chessish.com mailto:[EMAIL PROTECTED] ----- Original Message ----- From: Steve Jackson <[EMAIL PROTECTED]> To: PHP General <[EMAIL PROTECTED]> Sent: Thursday, December 12, 2002 9:00 AM Subject: [PHP] Update query > How do you update MySQL in the following way? > I have designed a form which has all the fields in the database > available to edit based on a user query. The query is a field called > $ItemCode. > > If the user wants to change that $ItemCode field how do I update it? In > other words how do I use PHP to update the database row called $ItemCode > with a new $ItemCode where $ItemCode is $ItemCode? > > Here is what I've tried and failed at! > $oldItemCode = $ItemCode; > $query = "update products > set ItemCode='$newItemCode', > ItemName ='$ItemName', > catid = '$catid', > price = '$price', > description = '$description' > shortdesc = '$shortdesc' > where ItemCode='$oldItemCode'"; > > Steve Jackson > Web Developer > Viola Systems Ltd. > http://www.violasystems.com > [EMAIL PROTECTED] > Mobile +358 50 343 5159 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
