You need a field named date and one field named time, in date format:
I set default to date: 0000-00-00
I set default to time: 00:00:00
then I select:
$query = "select * FROM news where TO_DAYS(NOW())-TO_DAYS(date)<=5 order by date desc, time desc" ;
$result = mysql_db_query("$db",$query,$connect);
this selects all news from the last 5 days with the newest entry being the first one.
visit my website@:
www.heimeshoff.de
