PHP/MySQL: Get one row and the next five rows

Question

I have one row that i can SELECT with the following command:

SELECT * FROM uploads WHERE upload_id = $upload_id

But I also want to get the 5 next rows. Using PHP, how can i do that? Order doesn't matter.

SELECT * FROM upload WHERE upload_id >= $upload_ID LIMIT 6, assuming things are sorted naturally by that upload_id — Marc B
– Marc B, Commented Nov 21, 2013 at 21:53
which 5 rows? 5 random rows, or 5 rows with the next upload ids? — rolfv1
– rolfv1, Commented Nov 21, 2013 at 21:53
How can you on one hand say you want the "NEXT" five rows and then also say "Order doesn't matter". These statements don't jive. What do you actually want? Is there an autoincrementing id here for upload_id? — Mike Brant
– Mike Brant, Commented Nov 21, 2013 at 21:54

OGHaza · Accepted Answer · 2013-11-21 21:54:20Z

1

To get that record and the next 5 ascending upload_ids:

SELECT * 
FROM uploads 
WHERE upload_id >= $upload_id
ORDER BY upload_id ASC
LIMIT 6

answered Nov 21, 2013 at 21:54

OGHaza

4,7957 gold badges26 silver badges30 bronze badges

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

Comments

Scott Helme · Accepted Answer · 2013-11-21 21:55:38Z

0

You can try:

select * from uploads where upload_id >= $upload_id order by upload_id asc limit 6;

You should also really avoid using select * and instead specify only the fields you need, even if that is all of the fields. That way if the schema changes in the future you aren't returning redundant data.

answered Nov 21, 2013 at 21:55

Scott Helme

4,7942 gold badges27 silver badges35 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL: Get one row and the next five rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related