Re: [PHP-DB] Update Statement

2004-02-18 Thread Ng Hwee Hwee
hwee - Original Message - From: "Ricardo Lopes" <[EMAIL PROTECTED]> To: "Ng Hwee Hwee" <[EMAIL PROTECTED]> Cc: "PHP DB" <[EMAIL PROTECTED]> Sent: Wednesday, February 18, 2004 5:41 PM Subject: Re: [PHP-DB] Update Statement > you could

Re: [PHP-DB] Update Statement

2004-02-18 Thread Ricardo Lopes
PROTECTED]> To: "DBList" <[EMAIL PROTECTED]> Sent: Wednesday, February 18, 2004 2:14 AM Subject: [PHP-DB] Update Statement hi all, I would like to do the following: update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no = Table2.no however, i found that multip

[PHP-DB] Update Statement

2004-02-17 Thread Ng Hwee Hwee
hi all, I would like to do the following: update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no = Table2.no however, i found that multiple updates can only work for MySQL version 4.0.4 but mine is 3.23.54... can anyone enlighten me on how I can achieve the same results with th