Is there a way to get 2 columns in 1 row, like this:

Record 1 | Record 2
-----------|----------
Record 3 | Record 4
-----------|----------
Record 5 | Record 6

thanks

I'm not sure what you mean. You mean you want to insert records into a table, but put them in rows of 2? You can use a count and count up, then use the modulus operator to see when to create a new row.

PHP Code:

<table>
<tr>
<?php
$counter = 0;
while($row = mysql_fetch_array($myresult))
{
    $counter++;
    if($counter % 3 == 0) // every 3rd item, make a new row
        echo "</tr><tr>";
    echo "<td>$mydata</td>";
}
?>
</tr>
</table>