Is it possible to retrieve data based on its date?

[judgenules]

Hello,

I have been searching everywhere on the net on how to retrieve data based on the dates. for eg. today's date. Is it possible to do this? If yes, how can it be done?

Thank u!

[Habtom]

If yes, how can it be done?

Since this is a PHP forum, I will show you how you can write the SQL query with an input from PHP.

Formatted current date:
$mydate = date("d-m-Y");

OR

if you have saved the date on timestamp:
$mydate = time();

mysql_query("SELECT * FROM table1 WHERE mydate = '". $mydate ."'")

Habtom