ดูให้หน่อยคับ มันเออเร่อ ตรง while ไม่รู้แก่ตรงไหนคับ

<?
		$sql="
			SELECT ProductID,Productname,number,price 
			FROM tb_product, tb_order_detail
			WHERE ProductID = id_prd and id_order='$id_order' ";

		$result=mysql_db_query($dbname,$sql);
		while ($rs=mysql_fetch_array($result)) {  
			$id_prd=$rs[id_prd];
			$code=sprintf("%05d",$id_prd);
			$Productname=$rs[Productname];
						
			$number=$rs[number];
			$price=$rs[price];
			$total_unit=$number*$price;
			$total=$total+$total_unit;
			echo "
				<TR>
					<TD>$code</TD>
					<TD>&nbsp;$Productname</TD>
					<TD><CENTER>$number</CENTER></TD>
					<TD><CENTER>$price</CENTER></TD>
					<TD><CENTER>$total_unit</CENTER></TD>
				</TR>";
		}
	?>