MySQL result in different pages

[Fsoft]

Hello,

<?php

$query = mysql_query("SELECT * from articles ORDER BY art_id DESC");
while($info = mysql_fetch_array($query))
{
echo $info["art_name"];
}
?>

 

Using this code, I am successfully able to print out (echo) all the article names in DESC order, the problem is I have 100 article names and I don't want them to echo on same page.. I want 10 articles on every page.. and then at the end of page, some thing like "Next..." when some one click on Next, they will see the names from 10 to 20 and then so on.. from 20 to 30, 30 to 40 ...

 

Please help friends I am stuck. Thanks a lot.

 

Faisal!!!

[jamesxg1]

I think this is a pagination job ,

 

See this tutorial: http://www.phpfreaks.com/tutorial/basic-pagination

 

James.