[Resolved] displaying most recent articles

proto

here's my code

<html>
<body>
<?
//connect to database
@ $db=mysql_pconnect("localhost","news","protox");

if (!$db)
{
	echo("couldn't connect");
	exit;
}

mysql_select_db("news");
$query="select * from articles";
$result=mysql_query($query);

if (!$result)
{
	echo("couldn't query");
	exit;
}

$num=mysql_num_rows($result);

for ($i=0; $i<5; $i++)
{
$row=mysql_fetch_array($result);
echo($row["title"]);
echo("<br><br>");
echo($row["author"]);
echo("&nbsp;&nbsp;");
echo($row["date"]);
echo("<p>");
echo($row["articles"]);
echo("<p>");
}
?>
</body>
</html>

this is a test version so I haven't paid much attention to text formatting. anyway, how do I make it so I only display the most recent news articles in my db? thanks in advance.

proto

someone pls help

wil

Try this.

$query="select * from articles ORDER BY 'some column' DESC";

You should have a column that gives you an auto incrementing number. I usually order by this column.

Hope this help,
Wil

proto

bump

proto

bump2

proto

bump3