1){ $textMsg = "Search Results"; }else{ $textMsg = "Search Result"; } echo "
✛ ".$textMsg." (".mysql_num_rows($result).")
"; echo "
"; echo "
"; echo ""; echo ""; while($row=mysql_fetch_array($result)){ ?>".$row['v_plate'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
PLATE CONDUCTION BRAND MODEL TYPE MAKE COLOR CUSTOMER NAME COMPANY LAST PMS DATE SOURCE DEALER TRANS. TYPE GAS TYPE
".$row['v_conduction']."".$row['v_brand']."".$row['v_model']."".$row['v_type']."".$row['v_make']."".$row['v_color'].""; $getFName = mysql_result(mysql_query("SELECT `cust_lname` FROM `vts_customers` WHERE `c_id`='".$row['cust_id']."'"),0); $getLName = mysql_result(mysql_query("SELECT `cust_fname` FROM `vts_customers` WHERE `c_id`='".$row['cust_id']."'"),0); echo $getLName .", " . $getFName; echo ""; $getCName = mysql_result(mysql_query("SELECT `business_name` FROM `businesses_names` WHERE `bid`='".$row['v_owner_fleet_id']."'"),0); echo $getCName; echo "".$row['v_last_pms_date']."".$row['sold_by_dealer']."".$row['v_gear']."".$row['gas']."
"; echo"
"; echo"
"; exit(); } ?>