retrieve entries added on certain date

With a simple add function I'm able to fill my database ..
To add a date to a new inserted record in mySQL, I use this:
$added = date ("YmdHis");

My question is: How do I retrieve all records that were added at the day the query is executed..

Also like to know how I print out all records that were added yesterday..

Can't figure it out..
Anyone?

thanx in advance...

Hi Trackz,

$added = date ("YmdHis");
Get php to make a variable containing the date in the format specified above. This would mean calling

$today = date ("Ymd");
$yesterday = date("Y").date("m").date("d")+1;

Then query the database with a string like:

$query = "SELECT the, fields, you, want, to, retrieve FROM table WHERE date like '%$date%' ";

Good luck,

Tuurlijk!

$yesterday = date("Y").date("m").date("d")+1;

Should read:

$yesterday = date("Y").date("m").date("d")-1;

Good luck,

Tuurlijk!

Off course, Tuurlijk! :-)

Thanx for info..
Sorry for late reply.. But E-mail wasn't working anymore, and lost my post..

Regards
Trackz.