I am using the open source script Phplist. I need a small query script (called qscript from now on) to identify email addresses that meet my criteria, within a database used by my installation of phpscript.
The qscript must be written in php and will be hosted on the same server where my PHPLIST is installed. When launched, qscript will
1) ask for my db details (user, password and database name)
2) ask for a starting and ending date
3) ask for a maximum number of mailing lists
The script will then go through the database and extract all the email addresses that were entered between the starting and ending date and that are subscribed to more than the maximum number of mailing lists.
The resulting email addresses will be presented in a download link to a csv file containing all the email addresses that were extracted.
If you are familiar with PHPscript, this should be very easy.
