How to compare input date to database

[Anon]

Please help me.....

any help i end with thank you...

How to compare date input dan date in database..

example:-

from date= today1(04/09/2001)
to date = input date(30/09/2001)

adn the databases search where the date is it...if search 'yes' and the databases display how many date same.

[znouza]

first you have to translate date to mysql format (if using mysql)

function ToMysql($date)
{
return preg_replace("/^{(\d{1,2})\/(\d{1,2})\/(\d{2,4})/","\3-\2-\1",$date}
}

and then build the sql query

$sql_query="select * from table where date>='".toMysql($to_date)."' and date<='".toMysql($from_date)."'";

and execute the query the way you like