dropdown menu คลิกแล้วให้โชว์ฐานข้อมูลขึ้นมา แต่มันโชว์แค่ข้อมูลเดียวอ่ะครับ รบกวนช่วยดูที

 <div id="cssmenu">
		<ul>
   			<li><a href="index.php"><img src="images/home.png" width="20" height="20"/> <span>Home</span> </a></li>
            <li><a href="profile.php"><span>Profile</span></a></li>
   			<li class="has-sub "><a href="#"><span>Products</span></a>
      			<ul>
	<?php
		$sql = "SELECT * FROM sp_type WHERE active = '1'";
		$qr = select($sql);
		$i = 0;
		
		while($i<count($qr))
		{
			$rs = $qr[$i];
			$i++;
			if($rs[name_type]!='')
			{
				$n_type = $rs[name_type];
	?>		
   			<li class="has-sub "><a href="main_product.php?id=<?=$rs[id_type]?>"><span><?=$n_type?></span></a>
    <?
				$sql2 = "SELECT * FROM sp_product WHERE name_type = '$n_type' AND active = '1'";
				$qr2 = select($sql2);
				$i2 = 0;
				
				while($i2<count($qr2))
				{
					$rs2 = $qr2[$i2];
					$i2++;
					if($rs2[name_type]!='')
					{
	?>
    	<ul>
			<li><a id="aaa" href="#"><span><?=$rs2[code]?> <img class="bbb" src="images/<?=$rs2[image]?>" height="80px" width="190"></span></a> <!-- บรรทัดเนี่ยอ่ะครับ มันเรียกข้อมูลมาได้แค่อันเดียว -->
            </li>
        </ul>
    <?					
					}
					else{echo'<a id="aaa" href="#"><span>haitian <img class="bbb" src="images/<?=$rs2[image]?>" height="80px" width="190"></span></a>';
				}
			}
			}
			else{echo'<li class="has-sub "><a href="#"><span>haitian</span></a>';}
		}
	?>
    		</li>
    		</ul>
   			</li>
   			<li><a href="contact.php"><span>Contact</span></a></li>
   			<li><a href="inquiry.php"><span>Inquiry</span></a></li>
            <li><a href="service_customer.php"><span>Service Customer</span></a></li>
		</ul>
        <div class="language">        	
			<img src="images/384880-English flag.png" title="english" width="25" height="15"/> | 
            <img style="opacity:0.4; filter:alpha(opacity=40);" src="images/Thailand02.png" title="thai" width="25" height="15"/>
		</div>
        <img src="images/logo_spi.gif" title="SPI Logo" onclick="window.location="index.php"" class="spi_logo" alt="spi logo"/>
	</div>