Getting results to display in two columns of a HTML table

[micmac]

Hi all,
How can i get the following script to display in two columns of a HTML table?
At the moment i have it displaying in one column.
If there are 5 results from the DB then the left HTML table column will display the 1st, 3rd and 5th result. The right HTML table column will display the 2nd and 4th results.

Here's the code to date:

<?
$result = mysql_query("SELECT * FROM ladies WHERE status = 'yes' ORDER BY first_name, last_name");
                            $total = mysql_num_rows($result);
                            while  ($row = mysql_fetch_array($result)) {

$lady_id = $row["lady_id"];
$first_name = $row["first_name"];
$last_name = $row["last_name"];
$list_pic = $row["list_pic"];
$new = $row["new"];
$status = $row["status"];

?>
<table cellpadding="5" cellspacing="0" border="0">
<tr>
<?

if($new == 'yes'){
echo "<td><img src=\"images/$list_pic\">&nbsp;&nbsp;<a href=\"models_profile.php?id=$lady_id\">$first_name $last_name</a>&nbsp;&nbsp;<img src=\"images/new_flash.gif\"></td>";
} else {
echo "<td><img src=\"images/$list_pic\">&nbsp;&nbsp;<a href=\"models_profile.php?id=$lady_id\">$first_name $last_name</a></td>";
}
}
?>			  

</TR>
</TABLE>

Any ideas on how to achieve this?

Cheers,
micmac

[crowezr]

I don't know if this is what you mean, but here is how I've handled this in the past.

$count = 0;
while($row = mysql_fetch_array($result))
{
if($count == 0)
{
echo '<tr><td>Some Data</td>';
$count = 1;
}
else
{
echo '<td>Some Data</td></tr>';
$count = 0;
}
}

I think this should work for what you need.

[AndyB40]

You need to move the <table> command out of the while loop (put it just before it), and then add <td></td> as the first part of the echo command after the line:
if($new == 'yes'){

and add <td></td> to the last part of the line:

echo "<td><img src=\"images/$list_pic\">__<a href=\"models_profile.php?id=$lady_id\">$first_name $last_name</a></td>";

This should force the results to display in the two columns.

I am assuming the if check is to decide which column the result should display in.