[SOLVED] Blog System
Posted: Thu Nov 27, 2003 9:17 am
I have a news blog system on my site. With my surrent code it only displays the first one in the database (so the oldest one). I want it to display the latest five. What peramiters do I have to add to acomplish this.
Here's my code:
Thanks for any help!
Here's my code:
Code: Select all
<?php
if ($auth == 1) {
$query = "SELECT * FROM news ORDER BY id DESC LIMIT 0 , 4";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_row($result) or die(mysql_error());
print "<BR><b>Author: </b> {$row['2']} <BR> <b>Subject: </b> {$row['3']} <BR> {$row['4']} <BR><BR>";
} ?>