How to search between dates with php mysql db questy results.

i need to get result for between particular dates or single day.

esp: get result from 01-02-2005 to 30-02-2005 or any dated between.

Please help me,

thanks.
iconsis online.

MySQL provides a neat function called BETWEEN and it is for this very purpose, however the format you are using above will not work with this solution. You will need to change your dates to one of the supported formats like so.

SELECT * FROM mytable WHERE date BETWEEN '2004-01-01 00:00:00' AND '2004-01-31 23:59:59';