title: how to program multi pages system in php
body: <p>I have PHP script and I programmed Topics system <BR>and I want to show every 10 topics in one page,, How to do that??<BR>
  sql table:</p>
  
  <pre><code>ID
  L_TITLE
  L_URL
  L_COMMENTS
  L_VIEWS
  L_STATE
  </code></pre>
  
  <p>php code:</p>
  
  <pre><code>$sql = mysql_query("SELECT * FROM LESSONS WHERE L_STATE='0' ORDER BY ID DESC") or die($sql_error);
  if(mysql_num_rows($sql) &gt; 0){
      while($rs = mysql_fetch_assoc($sql)){
          $l_id = $rs['ID'];
          $l_title = $rs['L_TITLE'];
          $l_comments = $rs['L_COMMENTS'];
          $l_views = $rs['L_VIEWS'];
      }
  }else{
          $l_id = $no_data;
          $l_title = $no_data;
          $l_comments = $no_data;
          $l_views = $no_data;
  }
  </code></pre>