Limiting size of a returned resultset in mySql in the query?

hailey · 07-13-2006

Hi,

I have a query that I am using in a paginated page

e.g. "select * from news"

what I want to do is for the first page get the first 20 say and then for the second get from 21 to 40 and so on.

Is this possible in the query?

I can obviously code it up to do the logic in PHP but that’s going to be inefficient and people might laugh at me behind my back.

Thanks,
Hailey

Francisjr · 07-14-2006

Try using

SELECT * FROM NEWS LIMIT 20

the operator LIMIT limits the size of the result set to 20.

imehesz · 07-14-2006

here is a nice explanation:

PHP Code:


			
SELECT * FROM tbl LIMIT 5,10;  # Retrieve rows 6-15

you can take a look at this link too:
http://dev.mysql.com/doc/refman/5.0/en/select.html

Ankita · 08-02-2006

Just use
Quote:

LIMIT

to specify how many records you want to show.

07-13-2006	#1 (permalink)
hailey Junior Member Join Date: Jul 2006 Age: 43 Posts: 9	Limiting size of a returned resultset in mySql in the query? Hi, I have a query that I am using in a paginated page e.g. "select * from news" what I want to do is for the first page get the first 20 say and then for the second get from 21 to 40 and so on. Is this possible in the query? I can obviously code it up to do the logic in PHP but that’s going to be inefficient and people might laugh at me behind my back. Thanks, Hailey

07-14-2006	#3 (permalink)
imehesz Senior Member Join Date: Jul 2006 Age: 30 Posts: 258	here here is a nice explanation: PHP Code: `SELECT * FROM tbl LIMIT 5,10; # Retrieve rows 6-15` you can take a look at this link too: http://dev.mysql.com/doc/refman/5.0/en/select.html __________________ -- iM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Query Correct?	gabriel	Site and Server Administration	1	07-21-2006 08:01 AM

07-14-2006	#2 (permalink)
Francisjr Member Join Date: Jul 2006 Age: 28 Posts: 61	Try using SELECT * FROM NEWS LIMIT 20 the operator LIMIT limits the size of the result set to 20.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

	All times are GMT. The time now is 09:00 PM.
	Contact Us - preCharge.Net - Archive - Privacy Statement - Top