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.
Mobile +358 50 343 5159

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to