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
> 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