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
