1){ $textMsg = "Search Results"; }else{ $textMsg = "Search Result"; } echo "
✛ ".$textMsg." (".mysql_num_rows($result).")
"; echo ""; echo ""; while($row=mysql_fetch_array($result)){ ?>".$row['u_name'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
USER ID FIRST NAME LAST NAME MOBILE NUMBER COMPANY DEALERSHIP POSITION E-MAIL ROLE
".$row['u_fname']."".$row['u_lname']."".$row['usr_mobile'].""; $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"".$dID."".$row['u_position']."".$row['email']."".$row['access_right']."".$row['account_type']."".$row['u_status']."
"; exit(); } ?>