USER ID | FIRST NAME | LAST NAME | MOBILE NUMBER | COMPANY | DEALERSHIP | POSITION | ROLE | ||||
---|---|---|---|---|---|---|---|---|---|---|---|
".$row['u_fname']." | "; echo "".$row['u_lname']." | "; echo "".$row['usr_mobile']." | "; echo ""; $cID = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='".$row['company']."'"),0); $dID = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$row['dealer']."'"),0); echo $cID; echo" | "; echo "".$dID." | "; echo "".$row['u_position']." | "; echo "".$row['email']." | "; echo "".$row['access_right']." | "; echo "".$row['account_type']." | "; echo "".$row['u_status']." | "; echo "✎ | "; echo "