'$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else { $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' ORDER BY `lname` ASC"); } break; //======================================================================================================================== case 'b': if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'c': if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tableb` LIKE '%$bb%' AND `$tablea` LIKE '%$aa%' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%'' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'd': if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =STRTOUPPER($value[1]); $searchValueDD =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD'ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled`LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND `$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%'' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'e': if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =STRTOUPPER($value[1]); $searchValueEE =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[1]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%' AND`$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` BETWEEN '$searchValueD' AND `$searchValueDD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'f': if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =STRTOUPPER($value[1]); $searchValueFF =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablea` LIKE '%$aa%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$dd%' AND `$tablea` LIKE '%$aa%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$bb%' AND `$tablea` = '$aa' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status` = '1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'g': if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =STRTOUPPER($value[1]); $searchValueGG =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` < '$searchValueG' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` > '$searchValueG' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec`LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$searchValueG' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` < '$searchValueA' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` > '$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef`LIKE '%$ff%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'h': if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =STRTOUPPER($value[1]); $searchValueHH =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND`$tableg` LIKE '%$gg%' AND AND `$tableh` < '$searchValueH' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee`LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND AND `$tableh` > '$searchValueH' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND AND `$tableh` = '$searchValueH' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` < '$searchValueA' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` > '$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg`LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg`LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` < '$searchValueG' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` > '$searchValueG' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee`LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$searchValueG' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh`LIKE '%$hh%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'i': if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =STRTOUPPER($value[1]); $searchValueII =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$searchValueI' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$searchValueI' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$searchValueI' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` BETWEEN '$searchValueI' AND '&searchValueII' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$ii' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$ii' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$ii' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$hh%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$ii' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$ii' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$ii' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'j': if($j==='AGE'){ $value = explode('+',$jj); $operator = STRTOUPPER($value[0]); $searchValueI =STRTOUPPER($value[1]); $searchValueII =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND`$tablej` < '$searchValueI' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` > '$searchValueI' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` = '$searchValueI' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` BETWEEN '$searchValueI' AND '&searchValueII' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `$tablei` LIKE '%$hh%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =$value[1]; $searchValueII =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablei` BETWEEN '$searchValueI' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'k': if($k==='AGE'){ $value = explode('+',$kk); $operator = STRTOUPPER($value[0]); $searchValueK =STRTOUPPER($value[1]); $searchValueKK =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` < '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` > '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` = '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` BETWEEN '$searchValueK' AND '&searchValueII' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `$tablei` LIKE '%$hh%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` AND `tablek` LIKE '%$kk%' LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =$value[1]; $searchValueII =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablei` BETWEEN '$searchValueI' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($j==='AGE'){ $value = explode('+',$jj); $operator = STRTOUPPER($value[0]); $searchValueJ =$value[1]; $searchValueJJ =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablej` BETWEEN '$searchValueJ' AND '$searchValueJJ' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `$tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== } echo "
"; echo ""; echo ""; echo ""; while($row = mysql_fetch_array($qq)){ $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); //echo "My Age: ".$newAge; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
LAST NAME FIRST NAME M.I ALIAS NATIONALITY GENDER BIRTHDATE AGE DATE HIRED
" . STRTOUPPER($row['lname']) . "" . STRTOUPPER($row['fname']) . "" . STRTOUPPER($row['mname']) . "" .STRTOUPPER($row['alias']) . "" .STRTOUPPER($row['nationality']) . "" .STRTOUPPER($row['gender']) . "" .STRTOUPPER($row['birthdate']) . ""; $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); if($newAge > 0){ echo $newAge; } echo "" .STRTOUPPER($row['date_hired']) . "
"; echo "
"; ?>