need a little help

[civicboy]

I am trying to create a table with 3 columns and however many rows it takes to complete the query. Right now I can get it to insert into a table but it will add each query as a row and wont do the columns right. Any help would be appreciated

here is the code i have so far:

<? 
$chandle = mysql_connect('server', 'username', 'pswd');  

$boolval = mysql_select_db('db', $chandle);  

$sql = mysql_query("SELECT DISTINCT MAKE FROM CARS");
{  

    echo '<table>'; 

    while ($row = mysql_fetch_array($sql))
    { 
        echo ' 
        <tr> 
        <td>' .$row["MAKE"]. '></td> 
        </tr> 
        '; 
    } 
    echo '</table>'; 
}  

?> 

Any help would be appreciated. thanks

[laserlight]

Hint: think in terms of modulo 3.
i.e.
0 = 0 (mod 3)
1 = 1 (mod 3)
2 = 2 (mod 3)
3 = 0 (mod 3)
4 = 1 (mod 3)
5 = 2 (mod 3)

etc.
The modulo operator is %, in case you didnt know.

[civicboy]

thanks i think i have it working now..

[civicboy]

how could i get this to work:

echo '<td width="25%"><a href="select_make.php?MAKE=$row[MAKE]">' . $row["MAKE"] . "</a></td>\n"; 

Trying to get the like to also show the make but it isnt working. Any thoughts?

sorry i got this working now..