โค๊ดครับ
$sql="SELECT * FROM order_tb AS h INNER JOIN products_tb AS p ON (h.product_id=p.product_id AND h.product_group=p.product_group) WHERE h.member_id ='".$u_id."' GROUP by order_id DESC";
//echo $sql;
$query=dbquery($sql);
$rows=dbrows($query);
#แบ่งหน้าแสดง
$per_page=20;
if (!$page) {
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;
// Set up specified page
$page_start = ($per_page * $page) - $per_page;
$result = mysql_db_query($dbname,$sql);
$num_rows = $rows ;
if ($num_rows <= $per_page) {
$num_pages = 1;
} else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
} else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;
if (($page > $num_pages) || ($page < 0)) {
error("You have specified an invalid page number");
}
$sql="SELECT * FROM order_tb AS h INNER JOIN products_tb AS p ON (h.product_id=p.product_id AND h.product_group=p.product_group) WHERE h.member_id ='".$u_id."' order by order_id DESC LIMIT $page_start, $per_page ";
//echo $sql;
$query=dbquery($sql);
$rows=dbrows($query);
if($rows>0)
{
$per_col=12;
$rowcount = 2;
echo "<table width='100%'>";
echo "<tr><td width='50%' valign='top'>";
WHILE($data=dbarray($query))
{
$rowcount++;
$qt=dbquery("SELECT cat_name FROM catalogs_tb WHERE cat_id='".$data['product_type']."' ");
$tdata=dbarray($qt);
$type=$tdata['cat_name'];
if($data['order_status']=='1'){
$status="Processing";
}else if($data['order_status']=='2'){
$status="Finish";
}else if($data['order_status']=='3'){
$status="Cancel";
}else{
$status="Waitting";
}
PRINT("<table cellpadding='3' width=100%>");
PRINT("<tr><td>");
$sql_order="SELECT * FROM order_tb WHERE member_id ='".$u_id."' GROUP by order_id DESC";
$query_order=dbquery($sql_order);
$order=dbarray($query_order);
PRINT('<table width=100% border=0 >
<tr>
<td width="9%" rowspan=8 align=center valign=top><a href="#" onClick="NewWindow(\''.BASEDIR.'pages/zoom.php?pid='.$data['product_id'].'&type='.$data["product_group"].'&v=1\',\'preview\',\'760\',\'580\',\'center\',\'Front\');"><img src="'.IMAGES.'products/thumbnall/'.$data['img1'].'" alt="" style="margin-right:19px; " align="left" border="0"></a></td>
<td align=\"right\">Date</td>
<td ><b>'.$data["date_order"].'</b></td>
</tr>
<tr>
<td align="right">Order No.</td>
<td><b>'.$data["order_no"].' </b></td>
</tr>
<tr>
<td align=\"right\">Product</td>
<td><a href="index.php?p=product_detail&pid='.$data["product_id"].'&type='.$data["product_group"].'"><strong>'.$data["product_name"].'</strong></a></td>
</tr>
<tr>
<td align="right">Group</td>
<td><b>'.$data["product_group"].'</b></td>
</tr>
<tr>
<td align="right">Qlt.</td>
<td><b>'.$data["order_quantity"].'</b></td>
</tr>
<tr>
<td align="right">Price</td>
<td><b>'.$data["price"].'</b></td>
</tr>
<tr>
<td align="right">Gold Market</td>
<td><b><font color="#FFFFFF">'.$data["goldmarket"].'</font></b></td>
</tr>
<tr>
<td align="right">Status</td>
<td>
<b><font color="#FF0000">'.$status.'</font></b></td>
</tr>
</table>
<img src="images/spacer.gif" alt="" width="1" height="7"><br><span>');
print('<div align="right">
<img src="images/a2.gif" alt=""><a href="index.php?p=product_detail&pid='.$data["product_id"].'&type='.$data["product_group"].'"> Details</a></div></span>');
PRINT("</td></tr>");
PRINT("</table><hr>");
if ($rowcount >= $per_col) {
echo "</td><td width='50%' valign='top'>";
$rowcount = 2;
}
}//End while
echo "</tr></table>";
#แสดงหน้า link ไปยังหน้าอื่นๆ
print "<table width='100%' border='0' cellspacing='0' cellpadding='0' align='center' >
<tr><td colspan=3 background=images/mem_line.png width=100% height=2></td></tr>
<tr><td colspan=3 height=5></td></tr>
<tr>
<td width='10%'> ";
if ($prev_page) { echo "<a href='index.php?p=member&page=$prev_page'><img src=images/icon_back.gif border=0 alt=Back></a>"; };
print " </td>
<td width='80%'>";
for ($i = 1; $i <= $num_pages; $i++) {
if ($i != $page) {
echo "l <a href=index.php?p=member&page=$i> $i </a>"; } else { echo "l <B><font color=red> $i </font></B>"; }
};
print "</td>
<td width='10%'> ";
if ($page != $num_pages) { echo " <B><a href='index.php?p=member&page=$next_page'><img src=images/icon_next.gif border=0 alt=next></a></B>" ; } ;
if ($page == 0 ) { echo "" ; } ;
print " </td>
</tr>
</table>";
#จบการแบ่งหน้า
