Re: [PHP-DB] Updating multilple tables?

2003-11-27 Thread Ignatius Reilly
nother table. Ignatius _ - Original Message - From: <[EMAIL PROTECTED]> To: "Ignatius Reilly" <[EMAIL PROTECTED]> Cc: "PHP DB list" <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 16:02 Subject: Re: [PHP-DB] Updating multilple tables? > All go

Re: [PHP-DB] Updating multilple tables?

2003-11-27 Thread Tristan . Pretty
xt all over my database. I'll get there...! ;-) "Ignatius Reilly" <[EMAIL PROTECTED]> 27/11/2003 15:02 To "PHP DB list" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> cc Subject Re: [PHP-DB] Updating multilple tables? One possible reason you did

Re: [PHP-DB] Updating multilple tables?

2003-11-27 Thread Ignatius Reilly
atius _ - Original Message - From: <[EMAIL PROTECTED]> To: "PHP DB list" <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 15:31 Subject: [PHP-DB] Updating multilple tables? > I have scattered around about 100 tables a block of text... > > I

Re: [PHP-DB] Updating multilple tables?

2003-11-27 Thread Miles Thompson
If you are searching in the same field (column) in each table, and the key field has the same name in all tables, build an array of table names and loop through it, executing your update on each iteration. Regards - Miles Thompson PS From your description it sounds as if you have a database des

[PHP-DB] Updating multilple tables?

2003-11-27 Thread Tristan . Pretty
I have scattered around about 100 tables a block of text... I wasn to serach through ALL my tables, and ALL my rows for this text, adn repalce it with another block of text. I've searched n google for "mysql multiple table update" But have yet to find an answer.. anyone know an easy way to do t