ช่วยหน่อยนะครับ การวนลูบ if เงือนไขที่ดึงมาจากฐานข้อมูล

	function show(){
					$s=100000;

		$r1=mysql_query("select  * from   tbl_rate  where rate_id = 1") or die(mysql_error());
		$rs1=mysql_fetch_array($r1);		
		$r2=mysql_query("select  * from   tbl_rate  where rate_id = 2") or die(mysql_error());
		$rs2=mysql_fetch_array($r2);			
		$r3=mysql_query("select  * from   tbl_rate  where rate_id = 3") or die(mysql_error());
		$rs3=mysql_fetch_array($r3);			
		$r4=mysql_query("select  * from   tbl_rate  where rate_id = 4") or die(mysql_error());
		$rs4=mysql_fetch_array($r4);	
		$r5=mysql_query("select  * from   tbl_rate  where rate_id = 5") or die(mysql_error());
		$rs5=mysql_fetch_array($r5);		
		$r6=mysql_query("select  * from   tbl_rate  where rate_id = 6") or die(mysql_error());
		$rs6=mysql_fetch_array($r6);			
		$r7=mysql_query("select  * from   tbl_rate  where rate_id = 7") or die(mysql_error());
		$rs7=mysql_fetch_array($r7);			
		$r8=mysql_query("select  * from   tbl_rate  where rate_id = 8") or die(mysql_error());
		$rs8=mysql_fetch_array($r8);	
		$r9=mysql_query("select  * from   tbl_rate  where rate_id = 9") or die(mysql_error());
		$rs9=mysql_fetch_array($r9);			
		$r10=mysql_query("select  * from   tbl_rate  where rate_id = 10") or die(mysql_error());
		$rs10=mysql_fetch_array($r10);			
		$r11=mysql_query("select  * from   tbl_rate  where rate_id = 11") or die(mysql_error());
		$rs11=mysql_fetch_array($r11);	
		

									
				if ($s <= $rs1[rate_stop]){
$data.= $rs1[rate_salary]+($s*$rs1[rate_commis]/100)+($s*$rs1[rate_bonus]/100);
				}
				else if ($s <= $rs2[rate_stop]){
$data.=   $rs2[rate_salary]+($s*$rs2[rate_commis]/100)+($s*$rs2[rate_bonus]/100);
				}		
				else	if ($s <= $rs3[rate_stop]){
$data.=  $rs3[rate_salary]+($s*$rs3[rate_commis]/100)+($s*$rs3[rate_bonus]/100);
				}
				else	if ($s <= $rs4[rate_stop]){
 $data.= $rs4[rate_salary]+($s*$rs4[rate_commis]/100)+($s*$rs4[rate_bonus]/100);
				}	
				else if ($s <= $rs5[rate_stop]){
$data.=   $rs5[rate_salary]+($s*$rs5[rate_commis]/100)+($s*$rs5[rate_bonus]/100);
				}		
				else	if ($s <= $rs6[rate_stop]){
$data.=  $rs6[rate_salary]+($s*$rs6[rate_commis]/100)+($s*$rs6[rate_bonus]/100);
				}
				else	if ($s <= $rs7[rate_stop]){
 $data.= $rs7[rate_salary]+($s*$rs7[rate_commis]/100)+($s*$rs7[rate_bonus]/100);
				}	
				else	if ($s <= $rs8[rate_stop]){
 $data.= $rs8[rate_salary]+($s*$rs8[rate_commis]/100)+($s*$rs8[rate_bonus]/100);
				}	
				else if ($s <= $rs9[rate_stop]){
$data.=   $rs9[rate_salary]+($s*$rs9[rate_commis]/100)+($s*$rs9[rate_bonus]/100);
				}		
				else	if ($s <= $rs10[rate_stop]){
$data.=  $rs10[rate_salary]+($s*$rs10[rate_commis]/100)+($s*$rs10[rate_bonus]/100);
				}
				else	if ($s > $rs11[rate_stop]){
 $data.= $rs11[rate_salary]+($s*$rs11[rate_commis]/100)+($s*$rs11[rate_bonus]/100);
				}	
							return $data;
	}