Update Multiple records
| From: | Ben Cairns | Date: | Thu, 17 May 2001 08:29:17 +0000 |
| Subject: | Update Multiple records | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9396@lists.php.net to get a copy of this message | ||
I want to update a MySQL db table, but I want to update multiple records,
Like this:
I want to run a statement like this:
update weld_details set parent = '1' where db_uid = '1','2'
Now, it dont work, and I cant see why, I think it has something to do with the
numbers at the end of the statement. But I cant see what...
Pls help.
Thanks in advance.
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: BenC@intasept.com
Web: http://www.intasept.com
"MAKING sense of
the INFORMATION
TECHNOLOGY age
@ WORK......"