You are here: Re: Date Formatting Help « All PHP « IT news, forums, messages
Re: Date Formatting Help

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация