> -----Original Message----- > From: Justin French [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 1:19 AM > To: [EMAIL PROTECTED]; 'php' > Subject: Re: [PHP] table-wide or database-wide search and replace? [snip] > > Give it a database name, the program find all the names of the tables, > > then loops through them all. It find all the rows for each table (maybe > > limit to just text based ones, to be fancy), and makes an sql statement > > to call the ereg. To really be feasible, you'd want to use the replace > > and regex functions already in MySQL. Only issues you may run into is > > the 30 second time limit... > > good point... specifically, is that a time limit imposed by mysql, php or > the browser you are referring to?
PHP limitation that scripts have 30 seconds to complete. This can be changed in PHP.ini or with a function call at the beginning of the script. > because i could do this on the command line (once off), and could also > break > the process into individual tables, or even groups of 50 rows or something > if needed -- although i'd do almost anything to avoid it :) ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
