CodingForums.com - View Single Post

Old Pedant · 03-01-2013, 06:07 PM

> if Genre Comedy have 30~ movies $MovieLisPerPage (is 5) code must create 6 pages.

Ummm... That is what LIMIT is for.

You will first do LIMIT 0, 5
Then LIMIT 5, 5
Then LIMIT 10, 5
etc.

But I think you knew that.

I don't know what else you are asking for.

Remember: I don't use PHP, so if it's a PHP question and not a MySQL question, I am probably not the right person to ask.

03-01-2013, 06:07 PM	PM User \| #21
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,200 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	> if Genre Comedy have 30~ movies $MovieLisPerPage (is 5) code must create 6 pages. Ummm... That is what LIMIT is for. You will first do LIMIT 0, 5 Then LIMIT 5, 5 Then LIMIT 10, 5 etc. But I think you knew that. I don't know what else you are asking for. Remember: I don't use PHP, so if it's a PHP question and not a MySQL question, I am probably not the right person to ask. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.