[SOLVED] Date() question

[ballhogjoni]

hey everyone, I have my code setup to save the date("Y-m-d") of each subscriber to my db when they subscribe. How can I automatically send an email to the subscriber a day later? Basically I want to query the db every day for the subs that subscribed yesterday and send them an email.

 

I need a code example on how to do this, I have search php.net and haven't found anything.

[haku]

Use chronjobs to run a phpscript on your server.

[ballhogjoni]

Yes I plan on using cron jobs. I was asking about the actual script that would run.

 

my thought is:

 

SELECT * FROM Table WHERE date = 'Yesterdays date';

 

I need the code for 'Yesterdays date'. Would it be something like date("Y-m-d") -1? I am a noob with the date() function.

[jorgep]

<?php echo date("Y m d",time()-(60*60*24)); ?>

The time function returns the number of seconds since 1970-01-01

the date function receive as a second parameter this number of seconds.

So when you say time()-(60*60*24) it means all that time minus 1 day.

Hope it helps

[p2grace]

Yesterday's date:

 

<?php

echo date("Y-m-d",strtotime("-1 day"));

?>

 

http://us.php.net/manual/en/function.strtotime.php

 

Should work like a charm