comparing the current row with previous row

[pbielma]

Hello,
I need to compare the value of the current with with the result of the previous row using php.

The code would loook like:

if($row['field']!==prev($row['field')){
echo $row['field'];
}

Basically, this is to be used to suppress repeating data.
so instead of:

field1 item1
field1 item2
field1 item3

I get

field1 item1
item2
item3

Thanks

[vallette]

How about something like this (assuming you're doing a 'sort by field' in your query:

if($currentfldvalue!=$row['field'])
{
echo $row['field'].' '.$row['item'].'<br>';
$currentfld=$row['field'];
}
else
{
echo $row['item'].'<br>';
}

[pbielma]

Thank you, that's it exactly. Just couldn't think of it.

btw, it should be:

$currentfldvalue=$row['field'];

thanks again!