help with pagination

[azegurb]

hi everyone
i want to build pagination with PHP but i cannot
for ex i have 100 number of news and i like my page show only 10 news per page so let it displays 10 page and below let it is written
page1, page2, page3, and whenever i want to click on this pages let it goes the page which is clicked
this my database sql.

CREATE TABLE `news` (
  id int(11) NOT NULL auto_increment,
  theme varchar(200) NOT NULL default '',
  author varchar(100) NOT NULL default '',
  date date NOT NULL default '0000-00-00',
  text text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

i did like this but it doesnt work

<?


@$db=mysql_connect('localhost','username','parol');
mysql_select_db('db_name');



$per_page=10;






$q="SELECT count(*) FROM `news`";
$res=mysql_query($q);
$row=mysql_fetch_row($res);
$total_rows=$row[0];
$num_pages=ceil($total_rows/$per_page);

echo '<h1>news</h1>';
$sql="SELECT * FROM `news` ";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result);
for ($i=0; $i<$num_results; $i++)
    {
    $row=mysql_fetch_array($result);

    $id=$row["id"];
    $author=$row["author"];
    $date=$row["date"];
    $tema=$row["tema"];    
    $text=$row["text"];

    echo '<b>'.$theme.'</b><br>

    <a href="/news/'.$id.'/">added by</a>: <b>'.$author.'</b> 

('.$date.')<p> '.$text.' <hr>';
    }

i need this script
if possible pls see it
Thanks for attention

[damnpoet]

i would recommend to use a pagination lib instead of making pagination yourself. I've used PHP Paginator a couple a times. It's a very simple pagination class, and very easy to use.

[azegurb]

i saw it but didnt understand. i need to apply it on my code
thank you for attention
if possible pls make changes on my code

[damnpoet]

sorry my bad, that's the right paginator... lol ;) this is http://www.phpclasses.org/browse/package/1239/download/targz.html

it includes examples that will help you use your code on it, check it out and let me know.