Small Problem

[mparab]

I have a query:

$query=mysql_query("SELECT * FROM timesheet WHERE authorized = 0 AND uname = $uname AND date BETWEEN ( NOW( ) - INTERVAL 14 DAY ) AND NOW( ) GROUP BY date DESC", $db);

It gives me the records for the last 14 days, which is perfect. But I don't get all the records. If a record has the same date as another record it does not display, neither do records with a date in the future.

Thanks,

M

[stolzyboy]

change "GROUP BY" to "ORDER BY" and see what happens

[mparab]

"Order By" gives me all the records in the database, I just need the last 14 days of records. Thanks though, it works in a way. Just not exactly how I need it to work, any other suggestions.

Thanks,

M