Hello guys can you help I create a table which appears all the transaction of all user. Just like the pic. below
I want to view only specific user receiver transaction. When this user receiver login to his/her account for example when user receiver in transaction # 5 login to her account it will appear only those transaction of her.
Here's my code
$qry = "SELECT en.`transid`, en.`transdate`,
CONCAT(userlist.lname, ', ', userlist.fname, ' ', userlist.mname) AS sender_name,
CONCAT(userlist1.lname, ', ', userlist1.`fname`, ' ', userlist1.`mname`) AS receiver_name,
en.`document_number`, doctype.`document_type`, vendor.`vendor_name`, acknowledge.`status_id`
FROM `tbl_encode_transmittal` en
LEFT JOIN `tbl_acknowledgetransmittal` acknowledge ON en.`transid` = acknowledge.`transid`
LEFT JOIN tbl_userlist userlist ON userlist.userid = en.sender_id
LEFT JOIN tbl_userlist userlist1 ON userlist1.userid = en.`receiver_id`
LEFT JOIN `tbl_doctype` doctype ON doctype.`doc_id` = en.`doctype_id`
LEFT JOIN tbl_vendor vendor ON vendor.`vendor_id` = en.vendor_id";
WHERE userlist.userid = '" . $_SESSION['userid'] . "'";
$res = mysql_query($qry) or die(mysql_error());
echo "<tr>";
while($row = mysql_fetch_array($res)){
echo "<tr>";
echo "<tbody>";
echo "<td>" . $row['transid'] . "</td>";
echo "<td>" . $row['transdate'] . "</td>";
echo "<td>" . $row['sender_name'] . "</td>";
echo "<td>" . $row['receiver_name'] . "</td>";
echo "<td>" . $row['document_number'] . "</td>";
echo "<td>" . $row['document_type'] . "</td>";
echo "<td>" . $row['vendor_name'] . "</td>";
echo "<td>" . $row['status'] . "</td>";
}