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
Navigation:
[Reply to this message]
|