<?php
$sql_dis="Select * from tb_members a
left join tb_project_reports b on (a.tb_member_id = b.tb_member_id)
left join tb_person_data c on (b.pjt_id = c.pjt_id) AND (b.tb_member_id = c.tb_member_id)
left join tb_work_today d on (b.pjt_id= d.pjt_id) AND (b.tb_member_id = d.tb_member_id)
left join tb_work_tomorrow e on (b.pjt_id = e.pjt_id) AND (b.tb_member_id = e.tb_member_id)
where a.tb_member_id ='".$tb_member_id."' order by b.pjt_id desc";
?>
<?
$sql = "
select * from tb_members a
inner join tb_project_reports b on a.tb_member_id = b.tb_member_id
inner join tb_person_data c on b.pjt_id = c.pjt_id
inner join tb_work_today d on a.tb_member_id = d.tb_member_id
inner join tb_work_tomorrow e on a.tb_member_id = e.tb_member_id
where a.tb_member_id = '".$tb_member_id."' order by b.bjt_id desc
";
?>
<?php
$sql_dis="SELECT * FROM tb_members
Inner Join tb_project_reports ON tb_members.tb_member_id = tb_project_reports.tb_member_id
where tb_members.tb_member_id ='".$tb_member_id."' order by tb_project_reports.pjt_id desc";
?>
<?php
$sql_dis="Select * from tb_project_reports a
left join tb_person_data b on (a.pjt_id = b.pjt_id)
where a.tb_member_id ='".$tb_member_id."' order by b.pjt_id desc";
?>