Sorting through values php mysql

Question

I have a database with rows containing an ID and a value.

I randomly insert these values between the numbers 1 and 100 as I insert records, so an ID has a random value. I use a while loop to go through the records and print them to screen. However, the way I want it is if the current value of the row in the while loop is LESS than the next value, then break out of the loop. Basically what I am asking is how to refer to the next record of a database while in a while loop working with the current, simply to check a value in it.

What exactly is your question?

Pekka
– Pekka

2010-11-22 11:37:03 +00:00
Commented Nov 22, 2010 at 11:37 — Pekka
– Pekka, Commented Nov 22, 2010 at 11:37

shamittomar · Accepted Answer · 2010-11-22 12:01:31Z

3

Try this:

$previousRow = mysql_fetch_assoc($result);
$previousRow['ID'] = -1;

while($currentRow = mysql_fetch_assoc($result))
{
    if($currentRow['ID'] > $previousRow['ID'])
         break;

    echo $previousRow['Value'];
    $previousRow = $currentRow;
}

edited Nov 22, 2010 at 12:01

answered Nov 22, 2010 at 11:40

shamittomar

46.8k12 gold badges77 silver badges81 bronze badges

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

3 Comments

Gumbo Over a year ago

I would rather initialize $previousRow['ID'] with 0 or -1.

Gumbo Over a year ago

I rather meant: Do not fetch the first row but just initialize $previousRow['ID'] with some value.

shamittomar Over a year ago

@Gumbo, but then echo $previousRow['Value']; won't work. So, it has to be fetched.

Quamis · Accepted Answer · 2010-11-22 11:37:47Z

0

$lastRecord = Array();
foreach($records as $thisRecord){
    if($lastRecord['value'] < $thisRecord['value']){
        // do what you need to do here
    }
    $lastRecord = $thisRecord;
}

This way you always keep the previous value stored

answered Nov 22, 2010 at 11:37

Quamis

11.2k13 gold badges54 silver badges67 bronze badges

Comments

poke · Accepted Answer · 2010-11-22 11:40:06Z

0

Do it the other way round. Instead of breaking out based on the next element, just check on the next element based on the previous element (which you can simply store somewhere). I guess that the loop actually loops through the elements and does something; you can then just check the previous/current element first before doing anything and nobody will notice that you in fact loaded the next element.

answered Nov 22, 2010 at 11:40

poke

392k80 gold badges596 silver badges632 bronze badges

Collectives™ on Stack Overflow

Sorting through values php mysql

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related