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

You can use some auto responder.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.