July 31st, 2003, 04:21 AM
|
|
Contributing User
|
|
Join Date: Jun 2003
Posts: 72
Time spent in forums: 11 m 36 sec
Reputation Power: 6
|
|
|
help with php list data script
how do you make it list from last to first?
PHP Code:
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM velocity_news LIMIT 3";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo "<b><center>news</center></b><br><br>";
$i=0;
while ($i < $num) {
$news=mysql_result($result,$i,"news");
$date=mysql_result($result,$i,"date");
$topic=mysql_result($result,$i,"topic");
echo "News for $date<br>";
echo "<b>$topic</b><br>";
echo "$news<br><br><br><br>";
++$i;
}
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
