ดึงข้อมูลจากตารางไม่ได้ ไม่รู้ว่าคำสั่ง while ผิดตรงไหนช่วยชี้แนะด้วยครับ

<?php


	
	echo "<table border='1' width=80% align=center>";
	print "<table width=800 align=center border=1>";
			print "<tr bgcolor=0066FF>";
				print "<td align = center  width=5%><font color=ffffff size=2>ลำดับ</font></td>";
				print "<td align = center  width=20%><font color=ffffff size=2>เรื่อง</font></td>";
				print "<td align = center  width=25%><font color=ffffff size=2>วันที่อบรม</font></td>";
				print "<td align = center  width=5%><font color=ffffff size=2>เวลา</font></td>";
				print "<td align = center  width=8%><font color=ffffff size=2>ค่าลงทะเบียน</font></td>";
				print "<td align = center  width=8%><font color=ffffff size=2>ค่าเดินทาง</font></td>";
				print "<td align = center  width=8%><font color=ffffff size=2>ค่าที่พัก</font></td>";
				print "<td align = center  width=8%><font color=ffffff size=2>ค่าเบี้ยเลี้ยง</font></td>";
				print "<td align = center  width=8%><font color=ffffff size=2>ค่าอื่น</font></td>";
				print "<td align = center  width=5%><font color=ffffff size=2>ลบ</font></td>";
				
			print "</tr>";
			
			
			
			//echo "?? ";
			$hostname = "localhost"; //?
			$user = "root"; //?
			$password = "root"; //??
			$dbname = "holiday"; //??
			//$tblname = "date"; //??
			 $sql1 =" select * from data_conf where id_user='$id_user'  ";
			 $sql2 =" select * from total_conf where id_user='$id_user'  ";
			 
			 
			

			//echo"$sql ";
			
			
			//echo $sql;
			// ติด ต่อ database
			mysql_connect($hostname, $user, $password) or die("cannot connect");
			// เลือก database
			mysql_select_db($dbname) or die("cannot select db");
			
			// ทำให้ อ่านภาษาไทยได้ใน utf8 
			mysql_query("SET NAMES utf8");
			
			$result1 = mysql_query($sql1);
			$row_number = mysql_num_rows($result1); // หาจำนวน แถว ข้อมูลที่ ค้นหาได้
			
			$result2 = mysql_query($sql2);
			$row_number = mysql_num_rows($result2); // หาจำนวน แถว ข้อมูลที่ ค้นหาได้
			
			
			
          $id=1;
               if($row_number > 0){
				while($record = mysql_fetch_array($result1)){
					 	$record1=$record["id_user"];
						$record2=$record["subject"];
						$record3=$record["date"];
						$record4=$record["hour"];
						$record5=$record["register"];
						$record6=$record["fare"];
						$record7=$record["rent"];
						$record8=$record["relate"];
						$record9=$record["other_mon"];
						$record10=$record["id_conf"];
						
						
				while($record = mysql_fetch_array($result2))		
						$record11=$record["id_total"];
						
						
						
		
								
						
						
			
			
	
						
			
						
		?>	
		
		
		
					
  <tr bgcolor="#F3F7FE" bordercolor="#0033FF">
               <td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:1%;"><a><?=$id?></a></td>
				<td style="font:Arial, Helvetica, sans-serif; color: #993399; text-align:center; font-size:12px; width:4%;"><b><?=$record2?></b></td>	
	            <td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:5%;"><a><?=$record3?></a></td>
				<td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:5%;"><a><?=$record4?></a></td>
				<td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:3%;"><a><?=$record5?></a></td>
				<td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:3%;"><a><?=$record6?></a></td>
				<td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:3%;"><a><?=$record7?></a></td>
				<td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:3%;"><a><?=$record8?></a></td>
				<td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:3%;"><a><?=$record9?></a></td>
				<td style="font:tahoma; color:#00008B; text-align:center; font-size:12px; width:5%;"><a href="delete2.php?id_conf=<?=$record10?> and id_total="<?=$record11?>runat="server" onclick="return submit2_onclick()">ลบ</a></td>
  </tr> 
  
  
		<?php
		$id++;
				}
			
			}
	//ไม่มีค่าส่งมา			
	
	
	echo "</table>";

?>