[RESOLVED] Populating a Table With Data From MYSQL

[whobutsb]

I have a mysql table with the column names like as "id" and "value" and "bizunit". I also have an HTML table that have unique DIV IDs that correspond with the mysql table. You can view the table at: www.newportharbor.com/Steve/test.php

I also have a mysql query that looks like this:

$query = "SELECT value FROM paceReport2 WHERE bizunit = 10"

How do I write a loop statement that will populate each of the cells in the HTML table?

[whobutsb]

Alright I did some tinkering and came up with this:

function getTablevalues()
{
	$query_biz = "SELECT * FROM paceReport2 WHERE bizunit = 10";
	$result = mysql_query($query_biz)
		or die(mysql_error());
$j =1 ;
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
	foreach ($row as $colname => $value)
	{
		$array[$j][$colname] = $value;
	}
	$j++;
}
return $array;
}
$tableValues = getTableValues();

That will run through the table and create a save location for the individual values. And then to display them in the table cells you add the following:

echo $tableValues[1]['value'];
echo $tableValues[2]['value'];

Just if you were wondering how to do it.