Alright What I need is I have it display the 4 lasest row by ID. What I need to know is how to make it display the next 4. Lets say we have ID 11, 10, 09, 08 on one page then they hit "old news" and it shows ID 07, 06, 05 , 04. and so on with out me manaully telling it them (07, 06, 05 ,04). How would I get this effect.
<?php
$db=mysql_connect("localhost","****","****") or die ("cant connect");
mysql_select_db("****",$db) or die ("cant change");
$news=mysql_query("select * from news ORDER BY ID DESC LIMIT 4") or die ("cant get em");
while($rows=mysql_fetch_array($news)){
$date=date("F d, Y H:i ",$rows["date"]);
$author=$rows["author"];
$content=$rows["content"];
echo "$content\n";
echo "$date\n";
echo "by $author\n";
}
?>
