In need of a genius

[whitebread]

Hello,

I'm trying to search between one date and another. I have the database with the date field setup (YYYY/DD/MM) and here is the query I'm using. However the query finishes without results or errors.

I really need someone's expertise.

Thanks

$sql_query = "select * from accounts where between General_Date = '" . $_SESSION['Date_Sub1'] . "' AND General_Date = '" . $_SESSION['Date_Sub2'] . "'"; 

[mrhappiness]

WHERE general_date between '2005-01-05' AND '2005-04-18'

maybe it only works if you use date date format of mysql shown above