On Thursday 12 December 2002 17:00, Steve Jackson wrote:
> 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!

Please, when something doesn't work, you got to describe _HOW_ it doesn't 

> $oldItemCode = $ItemCode;
>       $query = "update products
>              set ItemCode='$newItemCode',
>              ItemName ='$ItemName',
>              catid = '$catid',
>              price = '$price',
>              description = '$description'
>                        shortdesc = '$shortdesc'
>              where ItemCode='$oldItemCode'";

You seem to be missing a comma after --> description = '$description'

Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *

We all know that no one understands anything that isn't funny.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to