PHP Questions Home
Categories
Arrays
Files
Forms
Creating PDFs
PHP Errors
Functions
Images
MySQL
Numbers
Others
Strings
Website

PHP Forums
Forums Index
MySQL Forum
PHP Forum
Flash/Actionscript
Javascript
Web design

More PHP
PHP Functions
Top Questions
Ask a Question
PHP Interview Questions
PHP Jobs
Ecommerce
IT Questions
Business Websites

Sponsors

sponsor ad
My Salary
PHP Developer Salary
Advertise Here

How do I limit the number of rows returned?


You will often want to limit the number of rows returned from a database when provided with a query.

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);
?>



ASK A QUESTION

More mysql PHP Questions

How do I return the date with mySQL?

How do I return a random row from the database?

How do I access the current time with mysql?

Why does this code not work? Returns this error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ClaimNo = AND UserName = john' at line 2

How do I include a conditional in my mysql query?



Custom Search