AGE: ". $newAge ." HEIGHT: ".$vheight." cm WEIGHT: ".$vweight." lbs
";
echo "
NATIONALITY: ". $nationality ."
BUILT: ". $vbody ." type EYES: ".$veyes." color HAIR: ".$vhair." color
";
echo "
";
echo "";
}
//=================================
$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'];
$k=$_GET['k'];
$kk=$_GET['kk'];
$l=$_GET['l'];
$ll=$_GET['ll'];
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;
case 'TALENT_B':
$tablea='talent_skills';
break;
case 'WORKSHOP':
$tablea='workshop';
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':
$tableb='body_built';
break;
case 'LOOKS':
$tableb='talent_skills';
break;
case 'ROLE':
$tableb='talent_skills';
break;
case 'TALENT_B':
$tableb='talent_skills';
break;
case 'WORKSHOP':
$tableb='workshop';
break;
}
switch($c){
case 'WORKSHOP':
$tablec='workshop';
break;
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;
case 'TALENT_B':
$tablec='talent_skills';
break;
}
switch($d){
case 'WORKSHOP':
$tabled='workshop';
break;
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;
case 'TALENT_B':
$tabled='talent_skills';
break;
}
switch($e){
case 'WORKSHOP':
$tablee='workshop';
break;
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;
case 'TALENT_B':
$tablee='talent_skills';
break;
}
switch($f){
case 'WORKSHOP':
$tablef='workshop';
break;
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;
case 'TALENT_B':
$tablef='talent_skills';
break;
}
switch($g){
case 'WORKSHOP':
$tableg='workshop';
break;
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;
case 'TALENT_B':
$tableg='talent_skills';
break;
}
switch($h){
case 'WORKSHOP':
$tableh='workshop';
break;
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;
case 'TALENT_B':
$tableh='talent_skills';
break;
}
switch($i){
case 'WORKSHOP':
$tablei='workshop';
break;
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;
case 'TALENT_B':
$tablei='talent_skills';
break;
}
switch($j){
case 'WORKSHOP':
$tablej='workshop';
break;
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;
case 'TALENT_B':
$tablej='talent_skills';
break;
}
switch($k){
case 'WORKSHOP':
$tablek='workshop';
break;
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;
case 'TALENT_B':
$tablek='talent_skills';
break;
}
switch($l){
case 'WORKSHOP':
$tablel='workshop';
break;
case 'AGE':
$tablel='age';
break;
case 'BIRTHDATE':
$tablel='birthdate';
break;
case 'COURSE':
$tablel='course';
break;
case 'GENDER':
$tablel='gender';
break;
case 'NATIONALITY':
$tablel='nationality';
break;
case 'HEIGHT':
$tablel='height';
break;
case 'WEIGHT':
$tablel='height';
break;
case 'CITY':
$tablel='city';
break;
case 'TALENT':
$tablel='talent_skills';
break;
case 'BUILD':
$tablel='body_built';
break;
case 'LOOKS':
$tablel='talent_skills';
break;
case 'ROLE':
$tablel='talent_skills';
break;
case 'TALENT_B':
$tablel='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 '%$cc%' 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;
//========================================================================================================================
//========================================================================================================================
case 'l':
if($l==='AGE'){
$value = explode('+',$ll);
$operator = STRTOUPPER($value[0]);
$searchValueL =STRTOUPPER($value[1]);
$searchValueLL =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` LIKE '%$kk%' AND `$tablel` < '$searchValueL' 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` LIKE '%$kk%' AND `$tablel` > '$searchValueL' 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` LIKE '%$kk%' AND `$tablel` = '$searchValueL' 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` LIKE '%$kk%' AND `$tablel` BETWEEN '$searchValueL' AND '&searchValueLL' 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 `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablea` < '$searchValueA' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablea` > '$searchValueA' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablea` = '$searchValueA' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablea` BETWEEN '$searchValueA' AND '&searchValueAA' AND `tablej` LIKE '%$jj%' 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 `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '&searchValueBB' 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 `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' 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 `$tablel` LIKE '%$aa%' AND `$tablec` < '$searchValueC' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' 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 `$tablel` LIKE '%$aa%' AND `$tablec` > '$searchValueC' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' 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 `$tablel` LIKE '%$aa%' AND `$tablec` = '$searchValueC' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' 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 `$tablel` LIKE '%$aa%' AND `$tablec` BETWEEN '$searchValueC' AND '&searchValueCC' 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 `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$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 `$tablel` LIKE '%$aa%' AND `$tabled` < '$searchValueD' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$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 `$tablel` LIKE '%$aa%' AND `$tabled` > '$searchValueD' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$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 `$tablel` LIKE '%$aa%' AND `$tabled` = '$searchValueD' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$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 `$tablel` LIKE '%$aa%' AND `$tabled` BETWEEN '$searchValueD' AND '&searchValueDD' 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 `$tablek` LIKE '%$kk%' 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 `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablee` < '$searchValueE' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablee` > '$searchValueE' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' 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 `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablee` = '$searchValueE' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablee` BETWEEN '$searchValueE' AND '&searchValueEE' 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 `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablef` < '$searchValueF' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablef` > '$searchValueF' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablef` = '$searchValueF' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablef` BETWEEN '$searchValueF' AND '&searchValueFF' 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 `$tablek` LIKE '%$kk%' 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 `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableg` < '$searchValueG' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableg` > '$searchValueG' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' 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 `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableg` = '$searchValueG' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableg` BETWEEN '$searchValueG' AND '&searchValueGG' 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 `$tablek` LIKE '%$kk%' 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 `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableh` < '$searchValueH' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableh` > '$searchValueH' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' 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 `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableh` = '$searchValueH' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableh` BETWEEN '$searchValueH' AND '&searchValueHH' 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 `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablei` < '$searchValueI' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablei` > '$searchValueI' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablei` = '$searchValueI' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablei` BETWEEN '$searchValueI' AND '&searchValueII' AND `tablej` LIKE '%$jj%' 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 `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablej` < '$searchValueJ' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablej` > '$searchValueJ' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablej` = '$searchValueJ' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablej` BETWEEN '$searchValueJ' AND '&searchValueJJ' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC");
break;
}
}else if($K==='AGE'){
$value = explode('+',$KK);
$operator = STRTOUPPER($value[0]);
$searchValueK =$value[1];
$searchValueKK =$value[2];
switch($operator){
case 'LESS':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablek` < '$searchValueK' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC");
break;
case 'ABOVE':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablek` > '$searchValueK' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC");
break;
case 'EQUAL':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablek` = '$searchValueK' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC");
break;
case 'BETWEEN':
$qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' 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 `$tablel` LIKE '%$aa%' AND `$tablek` BETWEEN '$searchValueK' AND '&searchValueKH' AND `tablei` LIKE '%$ii%' 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%' AND `$tablek` LIKE '%$kk%' AND `$tablel` LIKE '%$ll%' ORDER BY `lname` ASC");
}
}
break;
//========================================================================================================================
}
echo "