Limiting While Loops

Weird1993 · #1 (**permalink**) Jul 8th, 2007, 16:34

Ok Webforumz, I need help... I'm a little stuck... Can anyone help me figure out how to use a while loop and limit the amount of rows of data it outputs? Basically, display the last 3 or so entries.

c010depunkk · #2 (**permalink**) Jul 8th, 2007, 20:51

umm, some code might help. Which programming language are we using?

Weird1993 · #3 (**permalink**) Jul 10th, 2007, 18:42

oops, forgot. PHP is what I'm using. The point is I'm trying to see if there is a code for it.

karinne · #4 (**permalink**) Jul 10th, 2007, 18:48

Shouldn't you be doing that in your sql query?

Something like

PHP: Select all


$GetLast3 = mysql_query("select * from table order by id desc limit 3");

c010depunkk · #5 (**permalink**) Jul 10th, 2007, 20:44

ummm. The while loop is the limit for how many lines of data get output:

PHP: Select all


$i=0;
while($i < 3) {
  // output stuff
  $i++;
}

but actually a for loop is better for something like that:

PHP: Select all


for($i=0;$i<3;$i++) {
  // output stuff
}

I hope I'm understanding your question right.

Weird1993 · #6 (**permalink**) Jul 12th, 2007, 04:33

Thanks for all the help everyone

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Logic Problem involving loops and arrays	tox0tes	Other Programming Languages	5	Oct 28th, 2007 03:11
Free Flash music and ambient loops	equinoxsounds	Flash & Multimedia Forum	3	Oct 12th, 2007 09:57
Limiting a while loop?	Weird1993	Databases	1	May 10th, 2007 19:51
Limiting Users Files in a Database...	JohnMitch	Classic ASP	3	May 13th, 2005 15:30
while loops?	mikegu	JavaScript Forum	1	Oct 26th, 2003 11:08

		Webforumz.com > Main Forums > Program Your Website > Databases
Limiting While Loops