ผมทำ code แบ่งหน้า ตอนที่ test ใช้ได้ แต่พออัพขึ้น host แล้วใช้ไม่ได้ครับ

<?
				  
				  require_once('connect/connect.php');
				  $sql_row = "select*from product ";
				  $query_row = mysql_query($sql_row);
				  $num_row = mysql_num_rows($query_row);
				  
				  $per_page = 4;
				  if(!$page)
				  $page = 1;
				  $next_page = $page+1;
				  $prev_page = $page-1;
				  $frist_page = ($per_page*$page)-$per_page;
				  if($num_row<=$per_page){
					  $num_page = 1;
				  }else if(($num_row%$per_page)==0){
					  $num_page = $num_row/$per_page;
				  }else{
					  $num_page = ($num_row/$per_page)+1;
				  }
				  $num_page = (int)$num_page;
				  
				  ?>
                  <!-- main table product -->
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr>
                    	<td>
                        <!-- sub table product -->
                        <?
						$i=0;
						$sql = "select*from product inner join pic_product on product.pro_id=pic_product.pro_id order by product.date desc limit $frist_page,$per_page";
						$query = mysql_query($sql);
						while($result = mysql_fetch_array($query)){
							$i++;
						?>
                        <table width="700" border="0" cellspacing="0" cellpadding="5">
                          <tr>
                            <td align="right" valign="top" width="150"><a href="detail_product.php?pro_id=<?=$result['pro_id'];?>" style="text-decoration:none;"><img src="pic_product/<?=$result['pic_1'];?>" width="150" style="border:1px solid #BBB; padding:2px;"/></a></td>
                            <td width="550" valign="top">
                            <!-- dics product -->
                            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                                <td>
                                  <table width="100%" border="0" cellspacing="0" cellpadding="6">
                                    <tr>
                                      <th align="left"><a href="detail_product.php?pro_id=<?=$result['pro_id'];?>" style="text-decoration:none;"><?=$result["pro_name"];?></a></th>
                                      <td align="right"><?=$result["date"];?></td>
                                    </tr>
                                  </table>
                                  </td>
                              </tr>
                              <tr>
                                <td>
                                  <table width="100%" border="0" cellspacing="0" cellpadding="5">
                                    <tr>
                                      <td width="20%"><strong><? if($result["mode"] != "วัตถุมงคล"){ echo "ราคา :"; }else{ echo "ราคาเช่า :"; }?></strong></td>
                                      <td width="80%"><font color="#FF0000"><?=$result["pro_price"];?> บ.</font></td>
                                    </tr>
                                    <tr>
                                      <td><strong>ค่าจัดส่ง :</strong></td>
                                      <td><font color="#FF6600">
									  <? 
									  if(($result["pro_send_price"] == 0)||($result["pro_send_price"] == "")||($result["pro_send_price"] == "-"))
									  {
										  echo "ฟรีค่าจัดส่ง";
									  }
									  else
									  {
										  echo $result['pro_send_price']." บาท";  
									  }
									  ?>
                                      </font></td>
                                    </tr>
                                    <tr>
                                      <td valign="top"><strong>รายละเอียด :</strong></td>
                                      <td><?=$result["pro_disc"];?></td>
                                    </tr>
                                  </table></td>
                              </tr>
                            </table>
							<!-- end dics product -->
                            </td>
                          </tr>
                          <tr>
                          	<td colspan="2" align="center"><img src="img/hr.jpg" width="650" height="10" /></td>
                          </tr>
                        </table>
                        <?
						}
						?>
						<!-- end sub table product -->
                        </td>
                    </tr>
                    <tr>
                    	<td>
                        <!-- btn page -->
                        <table width="100%" border="0" cellspacing="0" cellpadding="5">
                          <tr>
                            <td>&nbsp;</td>
                            <td align="center">หน้าที่ <b><? echo $page; ?></b> ทั้งหมด <b><? echo $num_page; ?></b> หน้า (รายการทั้งหมด <b><? echo $num_row; ?></b> รายการ)</td>
                            <td>&nbsp;</td>
                          </tr>
                          <tr>
                          	<td colspan="3" align="center">
							<? if($prev_page)  echo "<a href='$_SERVER[SCRIPT_NAME]?page=$prev_page'>BACK</a>&nbsp;";
							 for($i=1;$i<$num_page;$i++)
								if($i != $page)
									echo "<font color='#000000'>[ </font><a href='$_SERVER[SCRIPT_NAME]?page=$i'>$i</a><font color='#000000'> ]</font>";
								else
									echo "<font color='#666666'>[ $i ]</font>&nbsp;";
								
								
                             if($page!=$num_page) echo "<a href='$_SERVER[SCRIPT_NAME]?page=$next_page'>NEXT</a>"; ?>