[Resolved] Building a table based on count?

sgtpepper

Here is a sample of my simple little code

$query="SELECT * FROM agents";
$result=mysql_query($query) or die (mysql_error());
while ($row = mysql_fetch_array($result)) // this will grab the results from query

{
$name[]= $row[agent_name];
}
$howmany = count($name);
echo $howmany;

What I would like to be able to do is create a table based on the count given in $howmany. In this example $howmany=6

So, how can I creata a 2 column table....and have the table smart enough to know it needs to create 3 rows to fill in the data with?

So the tables gets created on the fly and fills in like this?

Any ideas?

devinemke

$query = 'SELECT * FROM agents';
$result = mysql_query($query) or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[] = $row['agent_name'];}
$array = array_chunk($array, 2);

echo '<table border="1">';
foreach ($array as $value)
{
	echo '<tr>';
	foreach ($value as $subvalue) {echo '<td>' . $subvalue .  '</td>';}
	if (count($value) < 2) {echo '<td>&nbsp;</td>';}
	echo '</tr>';	
}
echo '</table>';

sgtpepper

Excellent! Thank you...that seems to do the trick. Out of curiousity....how would I change the number of columns if needed?

sgtpepper

Ignore last post....it was easy to figure out....thanks!