File manager

File manager - Edit - /home/autoph/public_html/portal/includes/searchpage/b_bdate.php

Back
<?php GLOBAL $searchValueA; GLOBAL $searchValueB; GLOBAL $searchValueC; GLOBAL $searchValueD; GLOBAL $searchValueE; GLOBAL $searchValueF; GLOBAL $searchValueG; GLOBAL $searchValueH; GLOBAL $searchValueI; GLOBAL $searchValueJ; GLOBAL $searchValueK; $x=$_GET['x']; $a=$_GET['a']; $aa=$_GET['aa']; $b=$_GET['b']; $bb=$_GET['bb']; $c=$_GET['c']; $cc=$_GET['cc']; $d=$_GET['d']; $dd=$_GET['dd']; $e=$_GET['e']; $ee=$_GET['ee']; $f=$_GET['f']; $ff=$_GET['ff']; $g=$_GET['g']; $gg=$_GET['gg']; $h=$_GET['h']; $hh=$_GET['hh']; $i=$_GET['i']; $ii=$_GET['ii']; $j=$_GET['j']; $jj=$_GET['jj']; $j=$_GET['k']; $jj=$_GET['kk']; switch($a){ case 'AGE': $tablea='age'; break; case 'BIRTHDATE': $tablea='birthdate'; break; case 'COURSE': $tablea='course'; break; case 'GENDER': $tablea='gender'; break; case 'NATIONALITY': $tablea='nationality'; break; case 'HEIGHT': $tablea='height'; break; case 'WEIGHT': $tablea='height'; break; case 'CITY': $tablea='city'; break; case 'TALENT': $tablea='talent_skills'; break; case 'BUILD': $tablea='body_built'; break; case 'LOOKS': $tablea='talent_skills'; break; case 'ROLE': $tablea='talent_skills'; break; } switch($b){ case 'AGE': $tableb='age'; break; case 'BIRTHDATE': $tableb='birthdate'; break; case 'COURSE': $tableb='course'; break; case 'GENDER': $tableb='gender'; break; case 'NATIONALITY': $tableb='nationality'; break; case 'HEIGHT': $tableb='height'; break; case 'WEIGHT': $tableb='height'; break; case 'CITY': $tableb='city'; break; case 'TALENT': $tableb='talent_skills'; break; case 'BUILD': $tablea='body_built'; break; case 'LOOKS': $tablea='talent_skills'; break; case 'ROLE': $tablea='talent_skills'; break; } switch($c){ case 'AGE': $tablec='age'; break; case 'BIRTHDATE': $tablec='birthdate'; break; case 'COURSE': $tablec='course'; break; case 'GENDER': $tablec='gender'; break; case 'NATIONALITY': $tablec='nationality'; break; case 'HEIGHT': $tablec='height'; break; case 'WEIGHT': $tablec='height'; break; case 'CITY': $tablec='city'; break; case 'TALENT': $tablec='talent_skills'; break; case 'BUILD': $tablec='body_built'; break; case 'LOOKS': $tablec='talent_skills'; break; case 'ROLE': $tablec='talent_skills'; break; } switch($d){ case 'AGE': $tabled='age'; break; case 'BIRTHDATE': $tabled='birthdate'; break; case 'COURSE': $tabled='course'; break; case 'GENDER': $tabled='gender'; break; case 'NATIONALITY': $tabled='nationality'; break; case 'HEIGHT': $tabled='height'; break; case 'WEIGHT': $tabled='height'; break; case 'CITY': $tabled='city'; break; case 'TALENT': $tabled='talent_skills'; break; case 'BUILD': $tabled='body_built'; break; case 'LOOKS': $tabled='talent_skills'; break; case 'ROLE': $tabled='talent_skills'; break; } switch($e){ case 'AGE': $tablee='age'; break; case 'BIRTHDATE': $tablee='birthdate'; break; case 'COURSE': $tablee='course'; break; case 'GENDER': $tablee='gender'; break; case 'NATIONALITY': $tablee='nationality'; break; case 'HEIGHT': $tablee='height'; break; case 'WEIGHT': $tablee='height'; break; case 'CITY': $tablee='city'; break; case 'TALENT': $tablee='talent_skills'; break; case 'BUILD': $tablee='body_built'; break; case 'LOOKS': $tablee='talent_skills'; break; case 'ROLE': $tablee='talent_skills'; break; } switch($f){ case 'AGE': $tablef='age'; break; case 'BIRTHDATE': $tablef='birthdate'; break; case 'COURSE': $tablef='course'; break; case 'GENDER': $tablef='gender'; break; case 'NATIONALITY': $tablef='nationality'; break; case 'HEIGHT': $tablef='height'; break; case 'WEIGHT': $tablef='height'; break; case 'CITY': $tablef='city'; break; case 'TALENT': $tablef='talent_skills'; break; case 'BUILD': $tablef='body_built'; break; case 'LOOKS': $tablef='talent_skills'; break; case 'ROLE': $tablef='talent_skills'; break; } switch($g){ case 'AGE': $tableg='age'; break; case 'BIRTHDATE': $tableg='birthdate'; break; case 'COURSE': $tableg='course'; break; case 'GENDER': $tableg='gender'; break; case 'NATIONALITY': $tableg='nationality'; break; case 'HEIGHT': $tableg='height'; break; case 'WEIGHT': $tableg='height'; break; case 'CITY': $tableg='city'; break; case 'TALENT': $tableg='talent_skills'; break; case 'BUILD': $tableg='body_built'; break; case 'LOOKS': $tableg='talent_skills'; break; case 'ROLE': $tableg='talent_skills'; break; } switch($h){ case 'AGE': $tableh='age'; break; case 'BIRTHDATE': $tableh='birthdate'; break; case 'COURSE': $tableh='course'; break; case 'GENDER': $tableh='gender'; break; case 'NATIONALITY': $tableh='nationality'; break; case 'HEIGHT': $tableh='height'; break; case 'WEIGHT': $tableh='height'; break; case 'CITY': $tableh='city'; break; case 'TALENT': $tableh='talent_skills'; break; case 'BUILD': $tableh='body_built'; break; case 'LOOKS': $tableh='talent_skills'; break; case 'ROLE': $tableh='talent_skills'; break; } switch($i){ case 'AGE': $tablei='age'; break; case 'BIRTHDATE': $tablei='birthdate'; break; case 'COURSE': $tablei='course'; break; case 'GENDER': $tablei='gender'; break; case 'NATIONALITY': $tablei='nationality'; break; case 'HEIGHT': $tablei='height'; break; case 'WEIGHT': $tablei='height'; break; case 'CITY': $tablei='city'; break; case 'TALENT': $tablei='talent_skills'; break; case 'BUILD': $tablei='body_built'; break; case 'LOOKS': $tablei='talent_skills'; break; case 'ROLE': $tablei='talent_skills'; break; } switch($j){ case 'AGE': $tablej='age'; break; case 'BIRTHDATE': $tablej='birthdate'; break; case 'COURSE': $tablej='course'; break; case 'GENDER': $tablej='gender'; break; case 'NATIONALITY': $tablej='nationality'; break; case 'HEIGHT': $tablej='height'; break; case 'WEIGHT': $tablej='height'; break; case 'CITY': $tablej='city'; break; case 'TALENT': $tablej='talent_skills'; break; case 'BUILD': $tablej='body_built'; break; case 'LOOKS': $tablej='talent_skills'; break; case 'ROLE': $tablej='talent_skills'; break; } switch($k){ case 'AGE': $tablek='age'; break; case 'BIRTHDATE': $tablek='birthdate'; break; case 'COURSE': $tablek='course'; break; case 'GENDER': $tablek='gender'; break; case 'NATIONALITY': $tablek='nationality'; break; case 'HEIGHT': $tablek='height'; break; case 'WEIGHT': $tablek='height'; break; case 'CITY': $tablek='city'; break; case 'TALENT': $tablek='talent_skills'; break; case 'BUILD': $tablek='body_built'; break; case 'LOOKS': $tablek='talent_skills'; break; case 'ROLE': $tablek='talent_skills'; break; } switch($x){ case 'a': if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA = $value[1]; $searchValueAA = $value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else { $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' ORDER BY `lname` ASC"); } break; //======================================================================================================================== case 'b': if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'c': if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tableb` LIKE '%$bb%' AND `$tablea` LIKE '%$aa%' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%'' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'd': if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =STRTOUPPER($value[1]); $searchValueDD =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD'ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled`LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND `$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%'' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'e': if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =STRTOUPPER($value[1]); $searchValueEE =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[1]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%' AND`$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` BETWEEN '$searchValueD' AND `$searchValueDD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'f': if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =STRTOUPPER($value[1]); $searchValueFF =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablea` LIKE '%$aa%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$dd%' AND `$tablea` LIKE '%$aa%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$bb%' AND `$tablea` = '$aa' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status` = '1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'g': if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =STRTOUPPER($value[1]); $searchValueGG =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` < '$searchValueG' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` > '$searchValueG' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec`LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$searchValueG' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` < '$searchValueA' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` > '$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef`LIKE '%$ff%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'h': if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =STRTOUPPER($value[1]); $searchValueHH =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND`$tableg` LIKE '%$gg%' AND AND `$tableh` < '$searchValueH' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee`LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND AND `$tableh` > '$searchValueH' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND AND `$tableh` = '$searchValueH' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` < '$searchValueA' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` > '$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg`LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg`LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` < '$searchValueG' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` > '$searchValueG' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee`LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$searchValueG' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh`LIKE '%$hh%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'i': if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =STRTOUPPER($value[1]); $searchValueII =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$searchValueI' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$searchValueI' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$searchValueI' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` BETWEEN '$searchValueI' AND '&searchValueII' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$ii' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$ii' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$ii' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$hh%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$ii' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$ii' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$ii' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'j': if($j==='AGE'){ $value = explode('+',$jj); $operator = STRTOUPPER($value[0]); $searchValueI =STRTOUPPER($value[1]); $searchValueII =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND`$tablej` < '$searchValueI' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` > '$searchValueI' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` = '$searchValueI' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` BETWEEN '$searchValueI' AND '&searchValueII' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `$tablei` LIKE '%$hh%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =$value[1]; $searchValueII =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablei` BETWEEN '$searchValueI' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'k': if($k==='AGE'){ $value = explode('+',$kk); $operator = STRTOUPPER($value[0]); $searchValueK =STRTOUPPER($value[1]); $searchValueKK =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` < '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` > '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` = '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` BETWEEN '$searchValueK' AND '&searchValueII' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `$tablei` LIKE '%$hh%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` AND `tablek` LIKE '%$kk%' LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =$value[1]; $searchValueII =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablei` BETWEEN '$searchValueI' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($j==='AGE'){ $value = explode('+',$jj); $operator = STRTOUPPER($value[0]); $searchValueJ =$value[1]; $searchValueJJ =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablej` BETWEEN '$searchValueJ' AND '$searchValueJJ' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `$tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== } echo "<div STYLE='height: 400px; width: 100%; font-size: 12px; overflow: auto;'>"; echo "<table style='width:100%; height:100% border:1px solid gray; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' style='text-align:center;width:10px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:35px'></th> <th class='Gradient' align='left' style='width:148px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>LAST NAME</th> <th class='Gradient' align='left' style='width:100px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>FIRST NAME</th> <th class='Gradient' align='left' style='width:150px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>M.I</th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>ALIAS</th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>NATIONALITY</th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>GENDER</th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>BIRTHDATE</th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>AGE</th> <th class='Gradient' align='left' style='width:63px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>DATE HIRED</th>"; echo "</tr>"; while($row = mysql_fetch_array($qq)){ $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); //echo "My Age: ".$newAge; echo "<tr>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:center;width:10px;height:18px'> <a href='main_new.php?view=100&sview=1024&sid=&search=&view=plist&id=".$row['id']."&tab=0#id-0'><img src='images/rica/edit_a.png'></img></a> </td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:150px;height:18px;padding-left:5px'>" . STRTOUPPER($row['lname']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:100px;height:18px;padding-left:5px'>" . STRTOUPPER($row['fname']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:150px;height:18px;padding-left:5px'>" . STRTOUPPER($row['mname']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:50px;height:18px;padding-left:5px'>" .STRTOUPPER($row['alias']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:50px;height:18px;padding-left:5px'>" .STRTOUPPER($row['nationality']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:50px;height:18px;padding-left:5px'>" .STRTOUPPER($row['gender']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:50px;height:18px;padding-left:5px;background:yellow'>" .STRTOUPPER($row['birthdate']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:right;width:30px;height:25px;padding-right:10px;padding-left:5px'>"; $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); if($newAge > 0){ echo $newAge; } echo "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:center;width:50px;height:18px;padding-left:5px'>" .STRTOUPPER($row['date_hired']) . "</td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; ?>

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0.01 | proxy | phpinfo | Settings