How do I limit the number of rows returned?
Most often this is to reduce the amount of material returned, speed things up and make it useable via the web.
Often with paginated queries - e.g. 50, next 50, back 50 and so on this is also a technique you will see used.
It's easily done using the LIMIT structure with mysql which are then past an optional minimum and necessary max number of rows to return.
Thus to return 50 rows, do this:
<?php
$q = mysql_query("SELECT * FROM table LIMIT 50");
?>
If you want to return 20 rows starting at row 10, include the min part like so:
<?php
$q = mysql_query("SELECT * FROM table LIMIT 10,20);
?>
Comment on this Question and Answer >>>
ASK A QUESTION
More mysql PHP Questions
How do I find the number of rows in a result set?I am extracting data from a MySQL Database of which one of the data stored is seperated by a comma. For example, step1,go here,step 2,go there,step 3,go back etc etc. I want to know how to split the data at the comma and format it in html. Using the split
How do I group the results of a mysql query?
How do I find the ID of a new row added to a table?
How do I include a conditional in my mysql query?
