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).
----- 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
> 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.
> [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