cron job commands

[bunglebrown]

what is the technique for inputting a script or command as a cron job? I have a database table which I want to use to send emails.

 

[Christopher]

Can you explain some more what you are trying to do?

 

[bunglebrown]

Sure. I have a database table set up with 'name', 'email', 'subject', 'body' and 'send time'. 'Subject' and 'body' are always the same, but 'name' and 'email' are entered by the user which are saved into the database, the 'send time' records the time the details were submitted and adds three days - this is when I want an email containing this information in the database 'subject' & 'body' to the user. So I want to use a cron job command to somehow send this information on the 'send time' of each entry.

I hope this is clear and that you can help.

thanks

 

[TechAsh]

I recommend creating a PHP script that gets the information from the database and sends the e-mails.
You could then a a cron job to run the PHP script every so often (Not more than once every 5 minutes.)

php-cron -q /home/username/path/to/php/script.php