tables and columns

[listenmirndt]

Im pretty stumped,

I wonder if somone could put some hints into my code, trying to get this table to display 5 columns across, then go to the next row,

thanks in advance

echo '<br>';
echo '<table border="1" cellspacing="3" cellpadding="3" align="center" bordercolor="#E8EAE8">';

    $SQL = "SELECT * from LISTINGS WHERE CATAGORY='$cata'";
    $result = mysql_query( $SQL );
    while( $row = mysql_fetch_array( $result ) ) {

    $address = $row["ADDRESS"];
    $price = $row["PRICE"];
    $mainphoto = $row["MAINPHOTO"];
    $ide = $row["ID"];


//--

//--

echo '<td width="125">';
echo '<b><font face="Verdana, Arial, Helvetica, sans-serif" size="2">';
echo '<div align="center">';

    echo $address;
    echo '<br>';
    echo $price;
    echo '<br>';

    echo '<a href=main.php?id=';

    echo $ide;

    echo '>';

    echo '<img src="catagories';

    echo '/';

    echo $mainphoto;

    echo '" width="125"</a>';

    }




echo '</font></b>';
echo '</div>';

echo '</td>';

//--

//--

echo '</table>';

[ClevaTreva]

Hi

Without spending much time on this, I can see you are missing the <tr></tr> tags.

Your output should look like this:

<table>
<tr>
<td>column 1</td>
<td>column 2</td>
<td>column 3</td>
<td>column 4</td>
<td>column 5</td>
</tr>
etc

Trevor

[Weedpacket]

So count the number of records you've displayed, and insert </tr><tr> after every fifth.