My sql query for selecting specified data from table

Question

I have counter $i in my php page , so i want to get the next 15 records right from that $ith row. I am just using the below query bt it is returning empty output. I have plenty of records in db though

SELECT * FROM BOOKS WHERE @ROWNUM > '$i' LIMIT 15

why dont you use offset with limit

Muhammad Raheel
– Muhammad Raheel

2013-01-12 07:29:23 +00:00
Commented Jan 12, 2013 at 7:29 — Muhammad Raheel
– Muhammad Raheel, Commented Jan 12, 2013 at 7:29

Nutic · Accepted Answer · 2013-01-12 07:30:24Z

3

If I understand you right, you want to show 15 rows starting from $i ?

Try:

SELECT * FROM tbl_name LIMIT $i,15

answered Jan 12, 2013 at 7:30

Nutic

1,4294 gold badges16 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Saharsh Shah · Accepted Answer · 2013-01-12 07:35:44Z

1

You can build a query as

SELECT * FROM BOOKS LIMIT $i, 15;

Check this link MySQL SELECT with LIMIT

edited Jan 12, 2013 at 7:35

answered Jan 12, 2013 at 7:29

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

2 Comments

Php Geek Over a year ago

change it to SELECT * FROM BOOKS LIMIT $i, 15;

Saharsh Shah Over a year ago

Changed as you have specified

Collectives™ on Stack Overflow

My sql query for selecting specified data from table

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related