[blackcode]

i know how to display things in a mysql database, what i actually need is to limit my while loop to only display the first 20 things in the database and then have a next button to see the next 20 things in the database.

[Andy_1984]

and you have the balls to call me a lamer, ever heard of pagination ?

[blackcode]

lol, nope... didnt you say you were going somewhere else for help... and maybe you should go back and read what i posted the last time before you talk **** anyways i dont have time for this... and dont reply to this, i dont need your bs. what i need is a answer to my question now does anyone have the help cause obviously this fruitcake doesnt.

[NeverMind]

I'd like to ask you both to stop this immediately!
no more flamming.


http://www.phpsimplicity.com/tips.php?id=1
http://www.programmingtalk.com/showt...ght=pagination

[blackcode]

i appoligize, im not here to flame.. i gave it up i really dont care about this guy what so ever it is a big waste of time... i just had to reply to it. i didnt think i insulted him at all in that... sorry

[Andy_1984]

if you would read my post you would see i gave you an answer.

treat those as they would treat you

[End User]

Originally Posted by blackcode

i know how to display things in a mysql database, what i actually need is to limit my while loop to only display the first 20 things in the database and then have a next button to see the next 20 things in the database.

You know, you could probably solve half your programming problems by using Google. Just search for the answer and you'll almost certainly find it. People here get annoyed when they see someone asking questions without even *trying* to find it themselves first. I mean, really, this is NOT that hard to find using Google or any search engine. The fact that you haven't made the slightest apparent attempt at solving this yourself doesn't make me want to help you.

Now, if you came in here asking if anyone had pagination code to share, no problem. That's different. I have pagination code (which I've posted here before), but you wouldn't even take the time to look and see if this question had been answered before. Why should I have to post it repeatedly because you won't take a moment to try and help yourself?

Now, go to Google and type "php pagination example". Voila, problem solved.

[blackcode]

ok what am i suppose to search in google... "php 20 mysql query" like i didnt know what the **** it was called or i wouldnt be asking, and actually i did look though www.php.net and a php and mysql for dummies book so maybe you should keep comments to yourself when you dont know wtf is going on

[End User]

Originally Posted by blackcode

ok what am i suppose to search in google... "php 20 mysql query" like i didnt know what the **** it was called or i wouldnt be asking,

I can't help it if you're too ignorant to even know what to search for.

Originally Posted by blackcode

and actually i did look though www.php.net and a php and mysql for dummies book so maybe you should keep comments to yourself when you dont know wtf is going on

Lol, what a baby. I was going to copy a full set of pagination code in here for you, but I don't help ungrateful wankers.

[inContrast]

Whatever, I'm new here, so I'm just helping everyone.

Code:

//Couple Quick constant variables.
define("Jump_Count", "20");

//Now, how many entries are in the database?
$numCount=mysql_num_rows(mysql_query("SELECT * FROM table"));
//Returns: 24

//Have they clicked "Next" yet? if not, define the start as "0"
if(!isset($_REQUEST['start']) {
   $start=0;
}

//Now, let's display some.
//This will display the next 20 enteries after "Start"
while($ShowInfo=mysql_fetch_array(mysql_query("SELECT * FROM table LIMIT $start, Jump_Count))) {
   //Display whatever
}

//Should we display The Next and Previous links or not?
if($_REQUEST['start']==0||$_REQUEST['start']=='') {
   echo '<a href=thispage.php?start=' .$start-20. '><- Previous</a>
}
echo '||';
if($numCount>$start+20) {
   echo '<a href=thispage.php?start=' .$start+20. '>Next -> </a>
}

I apologize for any syntax errors or anything like that, at work and don't have access to any good color code editiors or anything. However, the threory should be fairly sound.