help with query to divide all data to pages (per page 10)

[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;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>';    }<?
 
 
@$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

[Atli]

Hey.

This is called "pagination", and it has been discussed endlessly on forums and blogs over the years (including this one).
See Google for a virtually endless amount of info on the subject.