PHP output couple times data from a column

Question

How do I output data from column, but to be like.. for example - the column is with 40 lines of query results and I want to output only that, that are from 10 to 30 . How to do it with PHP?

What does your database table look like? Also, if you can provide the code you have so far, that'll give us a better idea about what you're trying to accomplish. — Nasir
– Nasir, Commented Feb 9, 2011 at 15:13
What do you mean with a column? Are you trying to limit the amount of data you see of your database? Try using SQL's limit for that. — TJHeuvel
– TJHeuvel, Commented Feb 9, 2011 at 15:13

Joe Stefanelli · Accepted Answer · 2011-02-09 15:21:11Z

2

For MySQL, you could use a LIMIT offset, maxrows:

SELECT * FROM tbl LIMIT 9,20;

will get you rows 10-30. Note that the offset value is 0 based, hence the 9 rather than 10.

edited Feb 9, 2011 at 15:21

answered Feb 9, 2011 at 15:14

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

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

Collectives™ on Stack Overflow

PHP output couple times data from a column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related