roBofh — Sun, 09 Apr 2000 14:12:00 +0000

of course, there's always 'LIMIT'

Patrick Davis — Sun, 09 Apr 2000 05:16:00 +0000

I would just sort the entries in desendint order and pull out the first five.

Sort by date:
$query="SELECT * FROM news ORDER BY Date DESC";
$mysql_result=mysql_query($query);
while($row=mysql_fetch_row($mysql_result)){
//Do whatever needs to be done
}

Why am I not a moderator on this board

------------------
Good looking by Nature... Intelligent by Practice
http://dlo.net/process/profile.php3?user=Westwood

Rob Pengelly — Sun, 09 Apr 2000 04:54:00 +0000

Thanks. Just had to add a while($ticker <= 15) and it worked great.

------------------
http://www.wiredstart.com : The Technology Start Page