Posted by Chris on 05/26/05 19:54

"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


Geoff,

Exactly where would I put that code, in the recordset code at the top of the page? Sorry for my ignorance, I am very new to PHP.

Also, as you will see, I managed to get the date formatting working.

Thanks,

Chris

[Back to original message]