Mysql php compare datetime

[aks]

hi..
im having a pblm here...
im using a mysql database wch has a field created wch stores time n date in "2008-06-05 11:50:23 "format...i want to fetch entries from database between $start_date and $end_date..wch is in "2008-06-05" format...im using cakephp framework
$result= $this->DBModal->findAll(array($end_date > 'created','created' < $start_date));
$result is returning all the entries in database where as there is only 2 entries satifiyg the condition...
plz help me solve this...

thanks
aks

[Weedpacket]

Unless I'm mistaken, "'created' < $start_date" is not what you want.