<?php
session_start() ;
if(!session_is_registered("login_true")) {
echo "<meta http-equiv='refresh' content='0;url=../index.php'>" ;
exit() ;
}
include("../config.inc.php") ;
mysql_select_db($db) ;
$result = mysql_query("select * from member where user='$login_true'") or die ("Err Can not to result") ;
$dbarr = mysql_fetch_array($result) ;
?>
<?php
ob_start();
session_start();
include("../config.inc.php") ;
mysql_select_db($db) ;
/* $result = mysql_query("select * from member inner join orders on member.member_id = orders.member_id inner join order_details on orders.order_id = order_details.order_id where member.member_id = orders.member_id and orders.order_id=order_details.order_id") or die(mysql_error()); */
/* $result = mysql_query("select * from member inner join orders on member.member_id = orders.member_id inner join order_details on orders.order_id = order_details.order_id order by 'member_id'") or die(mysql_error()); */
/* $result = mysql_query("select member.*,orders.*,order_details.* from member,orders,order_details where member.member_id=orders.member_id=order_details.order_id where member_id='$member_id'") or die(mysql_error());
*/
$result = mysql_query("select member.member_id,orders.order_date,order_details.order_num,order_details.receiver_name,order_details.receiver_address,order_details.receiver_amper,order_details.receiver_province,order_details.receiver_zipcode,order_details.receiver_phone,order_details.status from member,orders,order_details where user='$login_true'") or die(mysql_error());
$dbarr = mysql_fetch_array($result) ;
while($dbarr = mysql_fetch_array($result))
{
?>
select
member.member_id,orders.order_date,order_details.order_num,order_details.receiver_name,order_details.receiver_address,order_details.receiver_amper,order_details.receiver_province,order_details.receiver_zipcode,order_details.receiver_phone,order_details.status
from member
inner join orders
on orders.member_id=member.member_id
inner join order_details
on order_details.order_id=orders.order_id
where
member.user='$login_true'
ฟิลด์ user อยู่ตารางไหนก็ไปแก้จาก member. เป็นตารางนั้นน่ะ
Load balance : Server 03
