Hi Ben,
I think U can use: [...] where db_uid = '1' or db_uid = '2' ...
OR [...] where db_uid in ('1', '2', ...)
Hope this helps.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
_______________________________________________________________
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
_______________________________________________________________
> -----Original Message-----
> From: Ben Cairns [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 17, 2001 10:29 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Update Multiple records
>
>
> 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: [EMAIL PROTECTED]
> Web: http://www.intasept.com
>
> "MAKING sense of
> the INFORMATION
> TECHNOLOGY age
> @ WORK......"
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
