query result!!!

[Anon]

hey,
I have this query to check if todays date is between a certain patroll time in the database.
$payrollQuery = "SELECT * FROM employee_payroll WHERE from_date<'date' AND to_date>'$date'";
the problem is that it is creating result according to alphabeticall order instead of
actuall dates.for examples when todays date is Feb04,2002, then it tells me its between Apr28,2002_____________May11,2002 period!!

anyone knows what I can do to solve this problem?

Rooin.

[Anon]

add an order by to the end of the query:

SELECT * FROM employee_payroll WHERE from_date<'date' AND to_date>'$date' order by date_field asc

the asc means ascending. you can replace it with a 'desc' for a descending order.

[Anon]

Are you storing the dates as dates or strings? As strings, "February" is between "April" and "May"!