Alt-PHP-Faq
Cheapest CO.UK domains in the UK! £1.88 per year!
And PHP/MySQL hosting 1p/1c for the first month, NO CATCH!


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



Free Forum    
Design & Layout Copyright © 2000- 2008 PHP MySQL Web Hosting Comments to Webmaster
Hosted by PHP 4 Hosting - PHP and MySQL Webhosting and Domain Names