Posted by Geoff Berrow on 05/26/05 09:49

I noticed that Message-ID: <zTWke.15108$WQ3.575@newsfe5-gui.ntli.net>
from Chris contained the following:

>Also does anyone know how I restrict the very top news item (with image) to the latest news item, by date and also have that
>particular news item not included on the list below.

Use ORDER BY date DESC

For the top item call the function just once.
$myrow = mysql_fetch_array($result);
//print top row items

Calling it again, in a loop, will retrieve the rest of the rows
excluding the top item

while($myrow = mysql_fetch_array($result)){

//print list

}

--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011

[Back to original message]