title: Fetching limited data from sql using PHP
body: <p>Actually i want to collect data from sql using php while command which is like:</p>
  
  <pre><code>while ($res = mysql_fetch_assoc($dat)){//code here}
  </code></pre>
  
  <p>But when i run it, it sends all the records in sql. I just want to display the limited records. How to do that. Even one more question with this can i split all the records into various pages?</p>