How do I limit results from a MySQL to 10 per page

[kpetsche20]

How do I limit results from a MySQL to 10 per page. I'm not exactly sure how many values there are in the database but I know there over a few hundred

[LemonInflux]

$sql = "SELECT * FROM `table` WHERE `field` = 'value' LIMIT 10"

 

LIMIT is what you need

 

On another note -- if you want to do, say, the second 10, it's like this:

 

$sql = "SELECT * FROM `table` WHERE `field` = 'value' LIMIT 10, 10"

 

This means select rows, limit 10, start after the tenth, so you get 11, 12, 13, 14, 15, 16, 17, 18, 19 and 20.

[kpetsche20]

What goes in the value spot?

[kpetsche20]

I need all the results to display, i dont want to limit the number of pages.

[LemonInflux]

Whatever you're getting from the database. If you don't want to filter it, you don't need that, and you can just use:

 

SELECT * FROM `table` LIMIT 10

 

All the value bit does is select from table WHERE the field (field name) is equal to the value (value name)

[LemonInflux]

How do I limit results from a MySQL to 10 per page. I'm not exactly sure how many values there are in the database but I know there over a few hundred

 

That sounds to me like you want to limit them?

[kpetsche20]

i want to limit the values to 10 values per page, with an unlimited number of pages

[kpetsche20]

$story = "SELECT * FROM stories WHERE name = '".$_GET['name']."' LIMIT 2";

 

 

 

That is what I have, it's not working though.

[kpetsche20]

Ok I got it to work, but the problem I face now is how do I add in buttons so people can go to the next pages.

 

$sql = "SELECT * FROM stories LIMIT 3";

[GingerRobot]

Im going to direct you to a very good tutorial on pagination:

 

http://www.phpfreaks.com/tutorial/basic-pagination

 

There's no point in us typing out another tutorial for you on the forums; so take a look at that one

 

 

[kpetsche20]

I was hoping to get an example of the correct code.

[GingerRobot]

I was hoping to get an example of the correct code.

 

There is an example of the correct code. On page 2 i believe.

[kpetsche20]

It makes no sense to me, that's a insert code.

[GingerRobot]

Perhaps you could try reading through the tutorial then? I'm sure if you had checked the next page/read a little, you would have noticed i was wrong and the code for the pagination is on page 3.

[kpetsche20]

I dont have time to read 12 pages of something I dont really understand anyway i just need the code. Is it really that complex to where someone can't just write it out for me real fast

[LemonInflux]

Being rude probably won't help. If you want someone to write you code, hire a programmer. This is a website for learning PHP. If you read the tutorial, you might just learn something about pagination.

[GingerRobot]

I was going to post a reply commenting on your attitude. But i wont waste my breath.