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['c_id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; echo ""; } echo "
CUST. ID FIRST NAME LAST NAME M. I GENDER BIRTH DATE MOBILE E-MAIL Facebook Tweeter InstaGram Viber Address Region Municipality City/Locality Barangay Company/Business Sector
".$row['cust_fname']."".$row['cust_lname']."".$row['cust_middle_name']."".$row['cust_gender']."".$row['cust_bday']."".$row['cust_mobile']."".$row['cust_email']."".$row['cust_fb']."".$row['cust_tweet']."".$row['cust_InstaG']."".$row['cust_viber']."".$row['cust_home_add']."".$row['cust_region']."".$row['cust_municipality']."".$row['cust_city']."".$row['brgy_name'].""; $getCName = mysql_result(mysql_query("SELECT `business_name` FROM `businesses_names` WHERE `bid`='".$row['cust_business_id']."'"),0); echo $getCName; echo ""; $getSName = mysql_result(mysql_query("SELECT `sectors_name` FROM `db_sectors` WHERE `sid`='".$row['sector_id']."'"),0); echo $getSName; echo " // //
"; echo"
"; echo"
"; exit(); } ?>