PHP/Mysql - Email

php, email, e-mail, sql, mysql

[oku86]

Hello everyone,

This has been annoying me for sometime, what i wish to do is send an email using results in my mysql database

i so the topic - [webmasterworld.com...] which is quite similar to what im after.

I have 1000's of records of domains the company i work for owns and i am tracking the renewals

i was wondering if there is a way of getting an automated email sent - via cron that will email me the results of the domains that will expire in 7 days time - the date format i use is YYYY-MM-DD

If anyone can point me in the right direction i'd be very greatful

[jatar_k]

sure, have your cron run daily

find today's timestamp
find the timestamp for 7 day from now

select from database where expiry_date between today and 7days

then have it chunk the domain names into an email