[SOLVED] How to Handle Query With Unknown Number of Results in 2 Columns?

[limitphp]

If I have a query that could return 0 or multiple results and I want to display them in a table in two columns, how do I handle it if there are an odd number of results and the second column won't get written?

 

Ex)

<table>
<?php
//query
$count = 1
while ($row_artist = mysql_fetch_assoc($result_artist_search))
{
     if($count & 1) //odd
     {
     echo "<tr>
                 <td>
                    <?php echo $row_artist['name'] ?>
                 </td>";
      }
      else //even
      {
          echo "<td>
                    <?php echo $row_artist['name'] ?>
                 </td>
             </tr>";
      }

      $count++;              

}
?>
</table>

 

What would be the best practice to handle displaying these artists if there are an odd number of them and I want to display them in two columns?

 

Right now, it wouldn't close the row if there are an odd number of artists.

thanks

[rhodesa]

after the loop, test the value of $count. if it's $even, you are good...if it's odd, print an empty cell and a close <tr>