คือ จะให้โชว์ตารางข้อมูลแบบแบ่ง page อ่ะครับ ไปดึงผลแบบ result set ขึ้นมาจาก 2 ตารางแล้ว ทำคำนวณแบ่งหน้า

 <form action="<?=$_SERVER['PHP_SELF'];?>" method="post" name="from" id="from" class="form-mar">
         			<fieldset>
         			  <legend align="center"><strong>ตารางรายการสินค้า</strong></legend>
                      <?
					  	$current_page=1;
						$rows_per_page=10;
					
						if(isset($_GET['page'])) {
							$current_page=$_GET['page'];
							}
						
						$start_page=($current_page - 1) * $rows_per_page;
						
						$sql_list0="SELECT * FROM products";
						$query_list0=mysql_db_query($dbname,$sql_list0);
						$total_rows=mysql_num_rows($query_list0);
						$total_page=ceil($total_rows / $rows_per_page);
						
						$url=$_SERVER['PHP_SELF'];
					  
					  ?>
                       <table width="750" cellpadding="0" cellspacing="0" border="0">
                            <tr>
                                <th width="72" align="center" class="line">รูปสินค้า</th>
                                <th width="120" align="center" class="line">รหัสสินค้า</th>
                                <th width="82" align="center" class="line">ชื่อสินค้า</th>
                                <th width="97" align="center" class="line">รหัสยี่ห้อสินค้า</th>
                                <th width="49" align="center" class="line">ราคา</th>
                                <th width="150" align="center" class="line">จำนวนคงเหลือ</th>
                                <th width="55" align="center" class="line">แกไข</th>
                                <th width="37" align="center" class="line">ลบ</th>
                           
						
						<?
							$sql_list="SELECT * FROM products order by Brand_ID limit $start_page, $rows_per_page ";
							$query_list=mysql_db_query($dbname,$sql_list) or die(mysql_error());
							while($rsl_list=mysql_fetch_array($query_list)) {
								$prd_id=$rsl_list['Prd_ID'];
								$prd_name=$rsl_list['Prd_Name'];
								$brand_id=$rsl_list['Brand_ID'];
								$price=$rsl_list['Price'];
								$prd_stock=$rsl_list['Prd_Stock'];
								
								$sql_img="SELECT * FROM images where Prd_ID='$prd_id' ";
								$query_img=mysql_db_query($dbname,$sql_img) or die(mysql_error());
								$res_set=mysql_fetch_array($query_img);
								$imgID=$res_set['imgID'];
								
								echo "
									<tr>
									<td width=\"50\" height=\"50\" align=\"center\"><img width=\"50\" height=\"50\" src=\"read_image.php?pid=$imgID \" /></td>
									<td align=\"center\" valign=\"middle\">$prd_id</td>
									<td align=\"center\" valign=\"middle\">$prd_name</td>
									<td align=\"center\" valign=\"middle\">$brand_id</td>
									<td align=\"center\" valign=\"middle\">$price</td>
									<td align=\"center\" valign=\"middle\">$prd_stock</td>
									<td align=\"center\" valign=\"middle\"><a href=\" \">แก้ไข</a></td>
									<td align=\"center\" valign=\"middle\"><a href=\" \">ลบ</a></td>
									</tr> ";
								 } 
								 ?>
                        <tr>
                        <td colspan="8"><hr /></td><tr>
                        <td align="left" valign="middle"><? echo "&nbsp;&nbsp; หน้าที่ :&nbsp;".$current_page;?></td>
                        <td colspan="7" align="right" valign="middle">
                         <?
						if($current_page > 1 ) {
							$pg=$current_page - 1;
							echo "<a href=\"$url?page=$pg\"> <<&nbsp;ย้อนกลับ </a>";
							}
							
						if($total_page > 1 ) {
						for($i=1;$i <= $total_page;$i++) {
							echo "<a href=\"$url?page=$pg\">|&nbsp; $i </a>";
							}
						}
						
						if($current_page < $total_page) {
							$pg=$current_page + 1;
							echo "<a href=\"$url?page=$pag\"> &nbsp;ถัดไป&nbsp;>> &nbsp; </a>";
							}
							
						?>                        
                        </td>	
                        </tr>
                        </table>
                    </fieldset>
                    </form>