ต้องการแบ่งข้อมูลที่่ คิวรี่ มาจากฐานข้อมูลออกเปนคอลัมน์ๆ

$Sql = mysql_query("select * from welding group by year");

$SqlYear = mysql_query("select year, sum(total) as sum_year from welding group by year");
$year = array();
$total_year= array();
echo "<table cellspacing=0>";
echo "<tr style='background:#EAEAEA;'><td colspan=2 >YEAR</td>";
while($objQuery = mysql_fetch_array($SqlYear))
{
	array_push($year, $objQuery['year']);
	array_push($total_year, $objQuery['sum_year']);
    echo "<td>".$objQuery['year']."</td>";
}
echo "<td>TOTAL</td>";
echo "</tr>";
$SqlBrand=mysql_query("select idbrand from welding group by idbrand");
$idbrand = array();
while($objQuery = mysql_fetch_array($SqlBrand)){
    $type = $objQuery['idbrand'];
	array_push($idbrand, $type);
}
$NO = 1;
for($ib=0;$ib<count($idbrand);$ib++){
	echo "<tr><td>".$NO."</td><td>".$idbrand[$ib]."</td>";
	$sum_btand=0;
	for($i=0;$i<count($year);$i++){
		$SqlData = mysql_query("Select sum(total) as sum_total from welding where year='$year[$i]' and idbrand='$idbrand[$ib]'")or die(mysql_error());
		$objData = mysql_fetch_array($SqlData);
		$data=$objData['sum_total'];
		$sum_btand=$sum_btand+$data;
		if($data==""){$data="-";}
		echo "<td>".$data."</td>";
	}
	echo "<td>".$sum_btand."</td>";
    echo "</tr>";
	$NO++;
}
$all_total=0;
echo "<tr style='background:#EAEAEA;'><td colspan=2>TOTAL</td>";
for($isum=0;$isum<count($total_year);$isum++){
	echo "<td>".$total_year[$isum]."</td>";
	$all_total=$all_total+$total_year[$isum];
}
echo "<td style='color:#FF0000;'>".$all_total."</td>";
echo "</tr>";
echo "</table>";