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.

  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,

i did like this but it doesnt work




$q="SELECT count(*) FROM `news`";

echo '<h1>news</h1>';
$sql="SELECT * FROM `news` ";
for ($i=0; $i<$num_results; $i++)


    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

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.

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