update multiple tables... ?
| From: | Chris Lee | Date: | Mon, 30 Oct 2000 06:56:39 +0000 |
| Subject: | update multiple tables... ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4057@lists.php.net to get a copy of this message | ||
update product, product_image set price = '35' where stockno = '123456'
product
-stockno
-price
-name
product_image
-stockno
-data
both stockno's are the same.
It would save me coding time if I was able to update both tables at the
same time, but I get an error in MySQL.
ERROR 1064: You have an error in your SQL syntax near ' product_image set price =
'37' where stockno = '972582589098437' at line
1
Chris Lee
Mediawaveonline.com