[RESOLVED] If last variable equals something in while loop

[TheCase]

Hi,

This is my code

  while ($row = mysql_fetch_assoc($query))
            {
            echo "<tr>

<td class='filtertable' bgcolor=\"{$colors[$row['status']]}\" align=\"center\"><p class='table'>{$row['username']}</p> </td>
<td class='filtertable' bgcolor=\"{$colors[$row['status']]}\" align=\"center\"><p>{$row['role']}</p></td>
          <td class = 'filtertable' bgcolor=\"{$colors[$row['status']]}\" align=\"center\"><p>{$row['comment']}</p></td>
      ";


        if ($num_rows_admin == 0)
            {
            echo "  <td class = 'filtertable' bgcolor=\"{$colors[$row['status']]}\" align=\"center\"><input type='button' value='Edit' class=\"button\" onClick='window.location.href=\"role.php?id=$row[id]\"  '></td> ";
            }

        echo ' </tr>';

        }

I'm trying to figure out how to check if $row['role'] does not equal the last one in the loop insert an empty row.

Thanks.

[Weedpacket]

I take it that by "last" you mean "previous".

$previous_role = null;
while($row=...)
{
...
   if($row['role'] != $previous_role)
    {
     /* $row['role'] does not equal the previous one in the loop; do whatever */
        $previous_role = $row['role'];
    }
...
}

[TheCase]

Great works perfectly, thanks