[PHP-DB] Exporting Data From MySQL Using PHP

I have created a MySQL database. The table I am creating is a subscriptions database. I want to be able to export all e-mail addresses stored in the "e_mail" column into a plain text file on the web server (1 e-mail address per row) where the "discipleship_mailing_list_e_mail_subscription" equals

Re: [PHP-DB] Timeout problem

Thanks for your suggestion, i don't know how that would actually be done, but still, I need to do this based on the selection done by the web user. The interfase is pretty like the phpMyAdmin, only much simpler, the options are to backup the entire database, just data or just structure. "Jonathan

Re: [PHP-DB] Timeout problem

can you just use a cron job and mysqlbackup instead? it does what you want and is already written. Jon Mauro Chojrin wrote: Hi: I'm developing a db application with php and I have this problem: I have a script for backup making which is very simple, it just goes through the entire database cre

[PHP-DB] Timeout problem

Hi: I'm developing a db application with php and I have this problem: I have a script for backup making which is very simple, it just goes through the entire database creating a file which contains the sql statements to re create the database. The first thing the script does y increase the tim

SV: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

Hi, Mysql_fetch_row() fetches an enumerated array, so it should be: If ($row[1] > 100) > > while ($row = @ mysql_fetch_row($result)) { foreach($row as $data) if > ({sum(number_o_beans)} > (100)) if($row['total_number_of_beans']) > 100) > print "\n\t {$data} "; > print "\n"; > }