สอบถาม SQL ที่ใช้สำหรับ Query ข้อมูลออกเป็นคอลัมน์

$objConnect = mysql_connect("localhost","root","pass") or die("Error Connect to Database");
$objDB = mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM Query WHERE product='กระเป๋า' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);

echo $objResult['product'].' | '.$objResult['amount'];
while($objResult = mysql_fetch_array($objQuery))
{
	echo ' | '.$objResult['amount'];
}

select product , group_concat(id,',') as gID from table where xxx group by product

while ( $ro = $result->fetch_object()){
  $id_list=explode(',',$ro);
?>
   <tr>
      <td><?=$ro->product?></td>
      <td><?=implode('</td><td>', $id_list)?></td>
   </tr>
<?php }