LinuxQuestions.org - PHP show query results

Hi Im currently showing my results as the below code, but that code display me the results exactly as my table on my DB. I would like to display the data on one row and down one row until some field name of X column change.

if the 4 fields on column A are the same print all the columns on one row and then if the next 5 fields on column A are differents as the first 4 fields down one row until a field name of A column change.. Thanks lot..

PHP Code:




<?php 
/* Connecting, selecting database */ 
$link = mysql_connect("mysql_host", "mysql_user", "mysql_password") 
   or die("Could not connect : " . mysql_error()); 
echo "Connected successfully"; 
mysql_select_db("my_database") or die("Could not select database"); 
 
/* Performing SQL query */ 
$query = "SELECT * FROM my_table"; 
$result = mysql_query($query) or die("Query failed : " . mysql_error()); 
 
/* Printing results in HTML */ 
echo "<table>\n"; 
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { 
   echo "\t<tr>\n"; 
   foreach ($line as $col_value) { 
       echo "\t\t<td>$col_value</td>\n"; 
   } 
   echo "\t</tr>\n"; 
} 
echo "</table>\n"; 
 
/* Free resultset */ 
mysql_free_result($result); 
 
/* Closing connection */ 
mysql_close($link); 
?>

This is my currently output.
-----------------------------------------
Champs 1 2
Champs 3 4
Champs 5 16
TETE 1 2
TETE 3 4
TETE 5 16

but I would like to print as:
-------------------------------------------
Champs 1 2 3 4 5 16
TETE 1 2 3 4 5 16