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
catid = '$catid',
price = '$price',
description = '$description'
shortdesc = '$shortdesc'
Viola Systems Ltd.
Mobile +358 50 343 5159
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php