ช่วยแนะนำการ select ข้อมูลรายการสินค้าออกมาในรูปแบบ แบบแยกประเภท ตามแต่ละรายการสินค้าจะทำการ select อย่างไรคะ ให้แสดงผลแบบภาพ

$result = query_mysql("SELECT * FROM types JOIN goods ON (types.type_id=goods.type_id)");

$type = null; // ตั้งให้เป็นค่า history
while($row = $result=fetch_assoc())
{
    if($type != null)
    {
        $type = $row['type_id']; // เซ็ทให้เป็นค่าเปรียบเทียบ
        echo '$row['type_name']';
    }

    echo '$row['goods_name']';
}

function search() {
include('include/config.inc.php');
echo <<<HTMLBLOCK

<form action="{$_SERVER['PHP_SELF']}" method="post">
    <table align="center" width="80%" border="0" class="style3">
    <tr><td align="center">
    ค้นหา สินค้า
    <input type='text' name='text1' size='15'>
    <select name="text2">
	<option value="" align="center">-----เลือกประเภทสินค้า-----</option>
HTMLBLOCK;
	$sql = "SELECT * FROM types order by type_name asc";
	$result = mysql_db_query($dbname, $sql);
    while($row = mysql_fetch_array($result)){
        echo "<option value='$row[type_id]'>$row[type_name]</option>";
    }
echo <<<HTMLBLOCK
	</select>
        <input type='submit' name='submitsearch' value=' ค้นหา '>
        </td></tr>
        </table>
</form>
HTMLBLOCK;
}

function show_form_edit() {
include('include/config.inc.php');
if(isset($_POST[submitsearch])){
$text1=$_POST[text1];
$text2=$_POST[text2];
}else{
$text1=$_GET[text1];
$text2=$_GET[text2];
}


if($text1!=""){
$send1 = "text1=$text1";
}
if($text2!=""){
    if($text1!="" and $text2!=""){
        $send2 = "&text2=$text2";
    }else{
        $send2 = "text2=$text2";
    }
}

$send="$send1$send2";

echo <<<HTMLBLOCK
    <table align="center" width="100%" border="0">
    <tr><td class="style4" height="30">
        <b>ข้อมูล</b>
    </td><td align="right"  class="style3"><br>
        <a href={$_SERVER['PHP_SELF']}?add=add><img src="icon/IM_31.jpg" width="90" height="69" title = "เพิ่มข้อมูล"/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a>
    </td></tr>
    </table>
HTMLBLOCK;

search();
$page = (isset($_GET['page']))? intval($_GET['page']) : 1;
$limit_end = 20;
$limit_start = ($page-1)*$limit_end;

if($text1!="" and $text2==""){
    $sql = "SELECT * FROM goods where goods_name like '%$text1%%' order by goods_id asc";

}elseif($text1=="" and $text2!=""){
    $sql = "SELECT g.* FROM goods g,types t WHERE g.type_id = t.type_id AND t.type_id =  '$text2%' ORDER BY g.goods_id ASC";
	
}elseif($text1!="" and $text2!=""){
    $sql = "SELECT g.* FROM goods g,types t  where g.type_id=t.type_id and g.goods_name like '%$text1%%' and t.type_id like '$text2%%'order by goods_id asc";
	
}else{
     $sql = "SELECT * FROM goods order by goods_id asc";
}

$query_id = mysql_db_query($dbname, $sql . " LIMIT " . $limit_start. "," . $limit_end);
$count = mysql_num_rows($query_id);
$total = mysql_num_rows(mysql_db_query($dbname, $sql));
if($total > 0){
	echo <<<HTMLBLOCK
<form method="POST" action="{$_SERVER['PHP_SELF']}">

        <table width="100%" align="center" border="0" class="style6">
        <tr><td>
HTMLBLOCK;

echo "<table width='100%' align='center' border='0' class='style3'>";
echo "<tr><td width='20%'>หน้า : " . page_navi($page, $limit_end, 4, $total, $send) . "</td><td align='right'  width='10%'>[" . ($limit_start+1) . "-" . ($limit_start+$count) . "] ทั้งหมด " . $total . "</td>";
echo "</table>";
	echo <<<HTMLBLOCK
        </td></tr>
        <tr><td align="center" valign="top" height="400">

<br>
<table width="95%" border="1" cellpadding="0" cellspacing="0" class="boder2">
	<tr align="center" height="30" class="style2">
	<td width='35%' bgcolor="#000099"><span class="style10">ประเภทสินค้า / ชื่อสินค้า</span></td>
    <td width='25%' bgcolor="#000099"><span class="style10">หน่วยนับ</span></td>
    <td width='25%' bgcolor="#000099"><span class="style10">ราคาขายส่ง</span></td>
    <td width='5%'></td>
    <td width='5%'></td>
    <td width='5%'></td>
    </tr>
HTMLBLOCK;


    $a=0;
while($a<$count){
$row = mysql_fetch_array($query_id);


    if($a%2==0){
        $color="#E8E8E8";
    }else{
        $color="#FFFFFF";
    }
$a++;
    $dog_id = "0000000000".$row[dog_id]; // เชื่อม ตัวเลขเข้าด้วยกัน
    $dog_id =substr($dog_id,strlen($dog_id)-3); // ตัดตัวเลขให้เหลือเพียง
    echo "<tr bgcolor='$color' class='style1'>";
	echo "<td align='left'>&nbsp;&nbsp;&nbsp;&nbsp;$row[goods_name]</td>";
    echo "<td align='center'>&nbsp;&nbsp;&nbsp;$row[goods_unit]</td>";

    $sql1 = "SELECT * FROM types WHERE type_id='$row[type_id]'";
	$result1 = mysql_db_query($dbname, $sql1);
    $row1 = mysql_fetch_array($result1);

   // echo "<td>&nbsp;&nbsp;&nbsp;$row1[type_name]</td>";
	echo "<td align= 'center'>&nbsp;&nbsp;&nbsp;$row[price]</td>";



?>
   <td align='center'><a href='dogs-detail.php?id=<?=$row[goods_id]; ?>' onclick="window.open(this.href, 'dogs_detail', 'width=600,height=600,left=350,top=50,scrollbars,resizable'); return false;"><img src='images/detail.gif' border='0' width='20' alt='ดูรายละเอียด'></a></td>
<?php
    echo "<td align='center'><a href='{$_SERVER['PHP_SELF']}?edit=edit&id=$row[goods_id]'><img src='images/b_edit.png' border='0' width='15' alt='แก้ไขข้อมูล'></a></td>";
    echo "<td align='center'><a href='{$_SERVER['PHP_SELF']}?edit=delete&id=$row[dog_id]' onclick=\"return confirm('คุณแน่ใจว่าจะลบข้อมูลนี้ ?')\"><img src='images/b_drop.png' border='0' width='15' alt='ลบข้อมูล'></a></td>";
    echo "</tr>";
}

	echo <<<HTMLBLOCK
</table>
      </td></tr>
      <tr><td>
HTMLBLOCK;

echo "<br><table width='100%' align='center' border='0' class='style3'>";
echo "<tr><td>หน้า : " . page_navi($page, $limit_end, 4, $total, $send) . "</td><td align='right'>[" . ($limit_start+1) . "-" . ($limit_start+$count) . "] ทั้งหมด " . $total . "</td>";
echo "</table>";


	echo <<<HTMLBLOCK
        </td></tr>
        </table>
</form>
HTMLBLOCK;

}else{
    echo '<table width="70%" align="center" border="0" height="250">';
    echo "<tr><td align='center' height='100'><font color='red'><b>ไม่พบข้อมูล</b></font></td></tr>";
	echo "</table><br>";
}
}