paid subs, email list

[dalai]

im sure someone must have asked it before, but is there an easy way of generating an email list for users who have paid subscription expiring between 2 dates.

i have over 1000 members who have paid subs, and i want to email only the ones who are due to expire in the next month, to offer them a discount.

i cant find anything in the manual, and even a sql query would help, but i dont know where to query it (tables, fields).

Craig

[Trevor Hannant]

If it's any help, this is the query from the includes/cron/subscriptions.php file that determines who is to get the reminders:

SELECT subscriptionlog.subscriptionid, subscriptionlog.userid, subscriptionlog.expirydate, user.username, user.email, user.languageid
        FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscriptionlog.userid)
        WHERE subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 2)) . "
            AND subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 3)) . "
            AND status = 1

[dalai]

i did run this, but got an error, my tables are VB_ then the table name, but the error was a syntax error, not an uknown table/column.

any other thoughts

Craig