How to add separator(s) in while loop?

[Dremoriand]

Lets say i have a mysql database with 2 columns and multiple rows. If i select them and do a regular while loop with mysql_fetch_array, it would print out:

a - 1
b - 1
c - 1
d - 2
e - 3
f - 3

What i'm trying to do is to make it print a separator when the value changes in the 2nd column, it would print:

a - 1
b - 1

c - 1

d - 2

e - 3
f - 3

Any suggestions?

[dalecosp]

You'll need to set an additional variable in the loop after each value is printed, say "$lastvalue".

Then, early in the loop, check to see if the value you are about to print is equal to the $lastvalue variable; if it's not, print the seperator ....

$foo=array(1,1,1,2,3,4,4,5,6);
foreach ($foo as $f) {
   if ($f!=$lastvalue) {
      echo "----- \n";
   }
   echo $f. "\n";
   $lastvalue=$f;
}