Posted by Chris on 05/26/05 10:36

"Geoff Berrow" <blthecat@ckdog.co.uk> wrote in message news:f0sa91p6kbq8n0cl61b42b575smfaup2lu@4ax.com...
> 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


Thanks for the answers guys, I think Paul has the answer to the formatting problem, that is what I need to do. Will give it a go
and if I have any problems will post back. Geoff, I will give your method a go for splitting the list.

Many thanks,

Chris

[Back to original message]