Update query
| From: | Steve Jackson | Date: | Thu, 12 Dec 2002 09:00:40 +0000 |
| Subject: | Update query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-127964@lists.php.net to get a copy of this message | ||
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
stephen.jackson@violasystems.com
Mobile +358 50 343 5159