<?php



    $searchCustTypeRel=$row161d['support_id'];

     if ($searchCustTypeRel ==8){
            $searchCustP=$row161d['overseer_id'];
     $sq112aaESP ="SELECT * FROM $table_name36 Where customer_id ='$searchCustP' ";
        $result333ESP = @mysql_query($sq112aaESP,$connection) or die(mysql_error());
while ($row1ESP = mysql_fetch_array($result333ESP)) {
        $searchCustP_first=$row1ESP['firstname'];
        $searchCustP_last=$row1ESP['lastname'];

            $searchtalk2 = "<br/>Search Restricted to Members Assigned to: $searchCustP_first $searchCustP_last ";
          $searchCustP_first='';
          $searchCustP_last='';
    } //while row1ESP


    $sq112aaESP ="SELECT * FROM $table_name36 Where salesrep_id ='$searchNonReg' ";
        $result333ESP = @mysql_query($sq112aaESP,$connection) or die(mysql_error());
   //  $row1E =mysql_fetch_array($result333E,MYSQL_ASSOC);
while ($row1ESP = mysql_fetch_array($result333ESP)) {

        $searchCustP_first=$row1ESP['firstname'];
        $searchCustP_last=$row1ESP['lastname'];
        $searchname .=   " OR (firstname LIKE '%$searchCustP_first%'    AND lastname LIKE '%$searchCustP_last%')";

                $searchCustP_first='';
          $searchCustP_last='';
    } //while row1ESP
 }  //searchCustP


 $searchCustP=$row161d['overseer_id'];

 if ($searchCustP !=0){

    $sq112aaESP ="SELECT * FROM $table_name36 Where customer_id ='$searchCustP' ";
        $result333ESP = @mysql_query($sq112aaESP,$connection) or die(mysql_error());
   //  $row1E =mysql_fetch_array($result333E,MYSQL_ASSOC);
while ($row1ESP = mysql_fetch_array($result333ESP)) {

        $searchCustP_first=$row1ESP['firstname'];
        $searchCustP_last=$row1ESP['lastname'];
        $searchname =   " AND (firstname LIKE '%$searchCustP_first%'    AND lastname LIKE '%$searchCustP_last%')";
        $searchtalk2 = "<br/>Search Restricted to Data from: $searchCustP_first $searchCustP_last ";
          $searchCustP_first='';
          $searchCustP_last='';
    } //while row1ESP
 }  //searchCustP


  $searchCustGroup=$row161d['customer_group_id'];
  if ($searchCustGroup !=0){

  $sq112aaESP1 ="SELECT * FROM $table_name362 Where customer_group_id ='$searchCustGroup' ";
        $result333ESP1 = @mysql_query($sq112aaESP1,$connection) or die(mysql_error());
   //  $row1E =mysql_fetch_array($result333E,MYSQL_ASSOC);
while ($row1ESP1 = mysql_fetch_array($result333ESP1)) {
$searchCustP_first1=$row1ESP1['name'];
 $searchtalk2 .= "<br/> Search Restricted to Data from Group: $searchCustP_first1  ";
 $searchCustP_first1='';
}


    $sq112aaESP ="SELECT * FROM $table_name36 Where customer_group_id ='$searchCustGroup' ";
        $result333ESP = @mysql_query($sq112aaESP,$connection) or die(mysql_error());
   //  $row1E =mysql_fetch_array($result333E,MYSQL_ASSOC);
while ($row1ESP = mysql_fetch_array($result333ESP)) {

        $searchCustP_first=$row1ESP['firstname'];
        $searchCustP_last=$row1ESP['lastname'];
        $searchname .=   " OR (firstname LIKE '%$searchCustP_first%'    AND lastname LIKE '%$searchCustP_last%')";
        // $searchtalk2= "Search Restricted to Data from: $searchCustP_first $searchCustP_last";
                   $searchCustP_first='';
          $searchCustP_last='';
    } //while row1ESP
 }  //searchCustP




      $searchNonReg=$row161d['other_id'];

     if ($searchNonReg !=0){

    $sq112aaESP ="SELECT * FROM $table_name80 Where map_id ='$searchNonReg' ";
        $result333ESP = @mysql_query($sq112aaESP,$connection) or die(mysql_error());
   //  $row1E =mysql_fetch_array($result333E,MYSQL_ASSOC);
while ($row1ESP = mysql_fetch_array($result333ESP)) {

        $searchCustP_first=$row1ESP['firstname'];
        $searchCustP_last=$row1ESP['lastname'];
        $searchname .=   " OR (firstname LIKE '%$searchCustP_first%'    AND lastname LIKE '%$searchCustP_last%')";
         $searchtalk2 .= "<br/> Search Restricted to Data from: $searchCustP_first $searchCustP_last";
                $searchCustP_first='';
          $searchCustP_last='';
    } //while row1ESP
 }  //searchCustP






 //   $searchCustTypeRel=$row161d['support_id'];

   // echo "$searchCustP  - $searchCustGroup  - $searchNonReg  - $searchCustTypeRel <br/>";

 // $sq112ZaAVV="SELECT * FROM $table_name103 WHERE van2 = '$searchP' ";
 //  $result3AVV = @mysql_query($sq112ZaAVV,$connection) or die(mysql_error());
 //         $num33AVV = mysql_num_rows($result3AVV);

 //if ($searchP >0 AND $num33AVV>0){
 //  $searchtalk="- Answer #: <u>$searchP</u>";
 //  $searchCheck='';
 //$searchCheck="AND  (company LIKE '%$searchP%' OR firstname LIKE '%$searchP%' OR email LIKE '%$searchP%'OR lastname LIKE '%$searchP%' OR  van1 LIKE '%$searchP%' OR van2 LIKE '%$searchP%' OR van3 LIKE '%$searchP%' OR van4 LIKE '%$searchP%' OR van5 LIKE '%$searchP%' OR van6 LIKE '%$searchP%' OR van7 LIKE '%$searchP%' OR van8 LIKE '%$searchP%' OR van9 LIKE '%$searchP%' OR van10 LIKE '%$searchP%' OR van11 LIKE '%$searchP%' OR van12 LIKE '%$searchP%' OR van13 LIKE '%$searchP%' OR van14 LIKE '%$searchP%' OR van15 LIKE '%$searchP%' OR van16 LIKE '%$searchP%' OR van17 LIKE '%$searchP%' OR van18 LIKE '%$searchP%' OR van19 LIKE '%$searchP%' OR van20 LIKE '%$searchP%' OR van21 LIKE '%$searchP%' OR van22 LIKE '%$searchP%' OR van23 LIKE '%$searchP%' OR van24 LIKE '%$searchP%' OR van25 LIKE '%$searchP%' OR van26 LIKE '%$searchP%' OR van27 LIKE '%$searchP%' OR van28 LIKE '%$searchP%' OR van29 LIKE '%$searchP%' OR van30 LIKE '%$searchP%' OR van31 LIKE '%$searchP%' OR van32 LIKE '%$searchP%' OR van33 LIKE '%$searchP%' OR van34 LIKE '%$searchP%' OR van35 LIKE '%$searchP%' OR van36 LIKE '%$searchP%' OR van37 LIKE '%$searchP%' OR van38 LIKE '%$searchP%' OR van39 LIKE '%$searchP%' OR van40 LIKE '%$searchP%' OR van41 LIKE '%$searchP%' OR van42 LIKE '%$searchP%' OR van43 LIKE '%$searchP%' OR van44 LIKE '%$searchP%' OR van45 LIKE '%$searchP%' OR van46 LIKE '%$searchP%' OR van47 LIKE '%$searchP%' OR van48 LIKE '%$searchP%' OR van49 LIKE '%$searchP%' OR van50 LIKE '%$searchP%' OR van51 LIKE '%$searchP%' OR van52 LIKE '%$searchP%' OR van53 LIKE '%$searchP%' OR van54 LIKE '%$searchP%' OR van55 LIKE '%$searchP%' OR van56 LIKE '%$searchP%') ";
 // $searchCheck300="AND  (van2 = '$searchP')";
//  echo  $searchCheck300;

  // echo $searchCheck;

     // create_date between '$lyear' AND '$tomorr' ";
//}

?>