Building a Table With PHP, how to do two columns

$query7 ="SELECT DISTINCT subCat1 FROM Products_copy_copy_copy_copy WHERE Manufacturer ='$manu' AND subCat1 <> '' ORDER BY subCat1 ASC";
		 $result7=mysql_query($query7);	
		 		 while(list( $subcat1a)= mysql_fetch_row($result7))
{
   
	$subcatstring = $subcat1a;
	$subcatstring = str_replace(' ', '', $subcat1a);	
	$subcatstring = strtolower($subcatstring);
	
fwrite($newfile,"
		
	            <td colspan=\"1\" class=\"textmain\"><div align=\"center\"><b><a href=\"$subcatstring/\">$subcat1a</a></b></div></td></tr>
      	  "); 
   
 }

Original - php Code <?php $dataTest = array(); $result = mysql_query($query); while($row = mysql_fetch_assoc($result)){ $dataTest[] = $row; } echo '<pre>'; print_r($dataTest); echo '</pre>'; ?>

<?php
$dataTest = array();
$result = mysql_query($query);
while($row = mysql_fetch_assoc($result)){
    $dataTest[] = $row; 
}
echo '<pre>'; print_r($dataTest); echo '</pre>';
?> 

Original - php Code <?php $dataTest = array('a','b','c','d','e','f','g'); $table = '<table>'; $counter = 0; // find total number of items in array. If it's not an even number // we need to add 1 so as to avoid breaking the table by // omitting the final cell $total = count($dataTest); if ($total%2 != 0) { $total+=1; } // loop through the array for ($i=0;$i<count($dataTest);$i++) { if ($counter%2 == 0) { // first column $table .= '<tr><td>' . $dataTest[$i] . '</td>'; } else { // second column $table .= '<td>' . $dataTest[$i] . '</td></tr>'; } $counter++; } // complete table and output results $table .= '</table>'; echo $table; ?>

<?php
$dataTest = array('a','b','c','d','e','f','g');
$table = '<table>';
$counter = 0;
// find total number of items in array. If it's not an even number 
// we need to add 1 so as to avoid breaking the table by 
// omitting the final cell
$total = count($dataTest);
if ($total%2 != 0) {
        $total+=1;
}
 
// loop through the array
for ($i=0;$i<count($dataTest);$i++) {
 if ($counter%2 == 0) { // first column
     $table .= '<tr><td>' . $dataTest[$i] . '</td>';
 } else { // second column
        $table .= '<td>' . $dataTest[$i] . '</td></tr>';
 }
 $counter++;
}
 
// complete table and output results
$table .= '</table>';
echo $table;
?> 

Original - php Code <?php // breaks array into required number of chunks function partition( $list, $p ) { $listlen = count( $list ); $partlen = floor( $listlen / $p ); $partrem = $listlen % $p; $partition = array(); $mark = 0; for ($px = 0; $px < $p; $px++) { $incr = ($px < $partrem) ? $partlen + 1 : $partlen; $partition[$px] = array_slice( $list, $mark, $incr ); $mark += $incr; } return $partition; } $dataTest = array('a','b','c','d','e','f','g'); // test data $table = '<table>'; $counter = 0; $arrayNum = 0; // split data into 2 chunks $splitData = partition( $dataTest, 2); // check if total number of items is an even number & add 1 if necessary $total = count($dataTest); if ($total%2 != 0) { $total+=1; } // loop through results for ($i=0;$i<$total;$i++) { // find whether we're using the first or second array on each loop // $set will be either 0 or 1 $set = $counter%2; if ($set == 0) { // first column $table .= '<tr><td>' . $splitData[$set][$arrayNum] . '</td>'; } else { // second column $table .= '<td>' . $splitData[$set][$arrayNum] . '</td></tr>'; // add one to $arrayNum ready for next row $arrayNum++; } $counter++; } // close table and output the results $table .= '</table>'; echo $table; ?>

<?php
// breaks array into required number of chunks
function partition( $list, $p ) {
    $listlen = count( $list );
    $partlen = floor( $listlen / $p );
    $partrem = $listlen % $p;
    $partition = array();
    $mark = 0;
    for ($px = 0; $px < $p; $px++) {
        $incr = ($px < $partrem) ? $partlen + 1 : $partlen;
        $partition[$px] = array_slice( $list, $mark, $incr );
        $mark += $incr;
    }
    return $partition;
}
 
$dataTest = array('a','b','c','d','e','f','g'); // test data
$table = '<table>';
$counter = 0;
$arrayNum = 0;
 
// split data into 2 chunks
$splitData = partition( $dataTest, 2); 
 
// check if total number of items is an even number & add 1 if necessary
$total = count($dataTest);
if ($total%2 != 0) {
        $total+=1;
}
 
// loop through results
for ($i=0;$i<$total;$i++) {
 // find whether we're using the first or second array on each loop
 // $set will be either 0 or 1
 $set = $counter%2;
 
 if ($set == 0) { // first column
     $table .= '<tr><td>' . $splitData[$set][$arrayNum] . '</td>';
 } else { // second column
     $table .= '<td>' . $splitData[$set][$arrayNum] . '</td></tr>';
     
     // add one to $arrayNum ready for next row
     $arrayNum++;
 }
 
 $counter++;
}
 
// close table and output the results
$table .= '</table>';
echo $table;
?>