script to query records from mysql and send emails?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Shell Scripting section within the Software Development category of DaniWeb, a massive community of 456,575 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,588 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Shell Scripting advertiser: Programming Forums

Thread Tools Display Modes

Views: 1130 | Replies: 1

•

Join Date: Oct 2007

Posts: 1

Reputation: nroper is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

nroper

Offline

Newbie Poster

script to query records from mysql and send emails?

Oct 26th, 2007

Hi,

I want to create a script that can be run daily(as cron job?) and which does the following:

1) Queries a MySQL database to return details of registered users.
2) For each user, compares their expiry date with today's date and if the remaining period is either 30,14,7,3,2 or 1 days sends them an email to say that their subscription will expire in 'n' days.

The main application uses MySQL & PHP, but I'm assuming I'd need a shell script in this case.

Any help gratefully received.

Thanks,

Nick