";
echo "
| RECORD ID |
FIRST NAME |
LAST NAME |
COMPANY |
DEALERSHIP |
REGISTERED MOBILE |
E-MAIL ADDRES |
STATUS |
ACTION |
";
while($row=mysql_fetch_array($result)){
?>
".$row['u_id']."";
echo "| ".$row['u_fname']." | ";
echo "".$row['u_lname']." | ";
echo "";
$compName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='".$row['company']."'"),0);
echo $compName;
echo " | ";
echo "";
$dealName = mysql_result(mysql_query("SELECT `deal_name` FROM `vts_dealerships` WHERE `deal_id`='".$row['dealer']."'"),0);
echo $dealName;
echo " | ";
echo "".$row['usr_mobile']." | ";
echo "".$row['email']." | ";
echo "";
if($row['u_status']== 0){echo 'For Activation';}else{echo 'Active';}
echo" | ";
echo "";
if($row['u_status']== 0){?>
";
echo " |
";
}
echo "";
?>
Admin Account:
";
echo "
| RECORD ID |
FIRST NAME |
LAST NAME |
ACCOUNT TYPE |
REGISTERED MOBILE |
E-MAIL ADDRES |
STATUS |
ACTION |
";
while($row=mysql_fetch_array($result)){
?>
".$row['u_id']."";
echo "| ".$row['u_fname']." | ";
echo "".$row['u_lname']." | ";
echo "".$row['account_type']." | ";
echo "".$row['usr_mobile']." | ";
echo "".$row['email']." | ";
echo "";
if($row['u_status']== 0){echo 'For Activation';}else{echo 'Active';}
echo" | ";
echo "";
?>
";
echo " |
";
}
echo "";
?>