Displaying query results in a table

[NiallThistle]

At the moment I have a script which will display a list of matching results, which usually lists 7-10 items in the results.

I want to display the results in a table if possible.

But I want to limit the table to three columns, how would I code this in?

Here is my existing code:

$kmaker = $_GET['maker'];
$makers = (int) $kmaker;

{
$get_kits = mysql_query("
SELECT K.kitid AS kit_id,
K.kitname AS kit_name,
K.kitmaker AS kit_maker,
M.makerid AS maker_id,
M.makername AS maker_name
FROM 1st_kits K, 1st_makers M
WHERE K.kitmaker = $kmaker AND
K.kitmaker = M.makerid
ORDER BY K.kitname",$connection)
or die(mysql_error());
}

if($kit_maker = $kmaker)
{
while($data = mysql_fetch_array($get_kits))
{
echo"
<a href='striptypes.php?maker=".$data[kit_maker]."&kit=".$data[kit_id]."&strip=0'>$data[maker_name] $data[kit_name]</a><br>";
}
}

[devinemke]

spool the results into an array and then use [man]array_chunk[/man] to split it up into groups of 3. a simple example:

$array = array(1,2,3,4,5,6,7,8,9);
$chunks = array_chunk($array, 3);

echo '<table border="1">';
foreach ($chunks as $value)
{
	echo '<tr>';
	foreach ($value as $sub_value)
	{
		echo '<td>' . $sub_value . '</td>';
	}
	echo '</tr>';
}
echo '</table>';

[NiallThistle]

Thanks devinemke.

Excuse my novice questions, but I'm a little unsure how my existing code would relate to introducing code required for array chunks.

Am I correct in assuming that the following may be correct:

$array = array($data);
$chunks = array_chunk($array, 3);

[devinemke]

// query code here

while ($data = mysql_fetch_array($get_kits)) {$array[] = $data;}
$chunks = array_chunk($array, 3);

echo '<table border="1">';
foreach ($chunks as $value)
{
    echo '<tr>';
    foreach ($value as $sub_value)
    {
        echo '<td><a href="striptypes.php?maker=' . $sub_value['kit_maker'] . '&kit=' . $sub_value['kit_id'] . '&strip=0">' . $sub_value['maker_name'] . ' ' . $sub_value['kit_name'] . '</a></td>';
    }
    echo '</tr>';
}
echo '</table>'; 

[NiallThistle]

Simply magnificent sir - thank you very much - that's exactly what I was looking for! 🙂