PHPFAQ - How do I limit the number of rows I get out of my database?

Question :
How do I limit the number of rows I get out of my database?

Answer :
Use LIMIT in your sql query like this:

SELECT name FROM table LIMIT 10

if you want to get the rows between 10 and 20 do the following:

SELECT name FROM table LIMIT 9, 10

Categories Return to Main PHP Faq

PHP & MySQL


Questions
PHP & MySQL
How do I store binary data in mysql?
What is the difference between mysql_connect() and mysql_pconnect()?
When I try to connect to mysql from php I get this error: "Call to unsupported or undefined function mysql_connect();"
How can I set the time zone for MySQL to UK time?

Return to the main FAQ list

Equine Supplements
Arthritis Pain Relief and UK Supplier of Cortaflex

Design & Layout Copyright © 2000- 2008 PHP MySQL Web Hosting Comments to Webmaster

Hosted by PHP 4 Hosting - PHP and MySQL Webhosting and Domain Names

Equine Supplements Arthritis Pain Relief and UK Supplier of Cortaflex
Design & Layout Copyright © 2000- 2008 PHP MySQL Web Hosting	Comments to Webmaster
Hosted by PHP 4 Hosting - PHP and MySQL Webhosting and Domain Names

How do I limit the number of rows I get out of my database?

Categories Return to Main PHP Faq

Questions