File manager - Edit - /home/autoph/public_html/portal/includes/searchpage/b_date_thumb.php
Back
<?php GLOBAL $searchValueA; GLOBAL $searchValueB; GLOBAL $searchValueC; GLOBAL $searchValueD; GLOBAL $searchValueE; GLOBAL $searchValueF; GLOBAL $searchValueG; GLOBAL $searchValueH; GLOBAL $searchValueI; GLOBAL $searchValueJ; GLOBAL $searchValueK; //PLAY VTR if(isset($_POST['playVTR'])){ $tID = $_POST['id']; $fName = mysql_result(mysql_query("SELECT `fname` FROM `talents_profile` WHERE `id`='$tID'"),0); $lName = mysql_result(mysql_query("SELECT `lname` FROM `talents_profile` WHERE `id`='$tID'"),0); $mName = mysql_result(mysql_query("SELECT `mname` FROM `talents_profile` WHERE `id`='$tID'"),0); $filePath = mysql_result(mysql_query("SELECT `file_code` FROM `vtr` WHERE `status`='1' AND `talent_id`='$tID'"),0); $myVideoPath = 'myvtr/'.$filePath; echo "<div style='position:absolute;top:10px;left:0px;border:1px solid black;width:600px;height:400px;background:#000;z-index:9999'>"; echo "<h3 class='titleBlue' style='padding-left:5px;padding-top:2px;font-family:Calibri;fotn-size:18px;font-weight:normal'>".$fName." ".$lName." - VTR</h3>"; ?> <video id="myVideo" width="600" height="370" controls autoplay poster="image/poster.png"> <source src="" type="video/mp4/avi/mpeg/vob/mob/vlc" /> <em>Sorry, your browser doesn't support HTML5 video.</em> </video> <?php //$videos="test.mp4"; //$videos[1]="http://somedomain2.com/video2.mp4"; //put your code here to convert $vid to $url of the video, e.g. $url=$videos; ?> <script> var vid=document.getElementById('myVideo'); vid.src='<?php echo $myVideoPath;?>'; </script> <?php echo "<div style='position:relative;width:581px;height:70px;background:white;border:1px solid black;left:-2px;padding:10px;'>"; echo "<p style='font-family:Calibri Light;font-size:12px;color:gray'>NAME: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'>". $fName ." ".$lName ."</b></p>"; echo "<p style='font-family:Calibri Light;font-size:12px;color:gray'>AGE: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'>". $newAge ."</b> HEIGHT: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'> ".$vheight."</b> cm WEIGHT:<b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'> ".$vweight." </b>lbs</p>"; echo "<p style='font-family:Calibri Light;font-size:12px;color:gray'>NATIONALITY: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'>". $nationality ."</b> BUILT: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'>". $vbody ."</b> type EYES: <b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'> ".$veyes."</b> color HAIR:<b style='font-family:Calibri Light;font-size:12px;color:gray;padding-left:10px;'> ".$vhair." </b> color <div style='position:absolute;top:50px;left:88%;width:50px;height:50px'> <form action='' method='POST'> <input type='hidden' name='id' value='".$row['id']."'> <input type='submit' name='closeVTR' value='CLOSE' class='submit'> </form> </div> </p>"; echo " </div>"; echo "</div>"; } //================================= $x=$_GET['x']; $a=$_GET['a']; $aa=$_GET['aa']; $b=$_GET['b']; $bb=$_GET['bb']; $c=$_GET['c']; $cc=$_GET['cc']; $d=$_GET['d']; $dd=$_GET['dd']; $e=$_GET['e']; $ee=$_GET['ee']; $f=$_GET['f']; $ff=$_GET['ff']; $g=$_GET['g']; $gg=$_GET['gg']; $h=$_GET['h']; $hh=$_GET['hh']; $i=$_GET['i']; $ii=$_GET['ii']; $j=$_GET['j']; $jj=$_GET['jj']; $k=$_GET['k']; $kk=$_GET['kk']; $l=$_GET['l']; $ll=$_GET['ll']; switch($a){ case 'AGE': $tablea='age'; break; case 'BIRTHDATE': $tablea='birthdate'; break; case 'COURSE': $tablea='course'; break; case 'GENDER': $tablea='gender'; break; case 'NATIONALITY': $tablea='nationality'; break; case 'HEIGHT': $tablea='height'; break; case 'WEIGHT': $tablea='height'; break; case 'CITY': $tablea='city'; break; case 'TALENT': $tablea='talent_skills'; break; case 'BUILD': $tablea='body_built'; break; case 'LOOKS': $tablea='talent_skills'; break; case 'ROLE': $tablea='talent_skills'; break; case 'TALENT_B': $tablea='talent_skills'; break; case 'WORKSHOP': $tablea='workshop'; break; } switch($b){ case 'AGE': $tableb='age'; break; case 'BIRTHDATE': $tableb='birthdate'; break; case 'COURSE': $tableb='course'; break; case 'GENDER': $tableb='gender'; break; case 'NATIONALITY': $tableb='nationality'; break; case 'HEIGHT': $tableb='height'; break; case 'WEIGHT': $tableb='height'; break; case 'CITY': $tableb='city'; break; case 'TALENT': $tableb='talent_skills'; break; case 'BUILD': $tableb='body_built'; break; case 'LOOKS': $tableb='talent_skills'; break; case 'ROLE': $tableb='talent_skills'; break; case 'TALENT_B': $tableb='talent_skills'; break; case 'WORKSHOP': $tableb='workshop'; break; } switch($c){ case 'WORKSHOP': $tablec='workshop'; break; case 'AGE': $tablec='age'; break; case 'BIRTHDATE': $tablec='birthdate'; break; case 'COURSE': $tablec='course'; break; case 'GENDER': $tablec='gender'; break; case 'NATIONALITY': $tablec='nationality'; break; case 'HEIGHT': $tablec='height'; break; case 'WEIGHT': $tablec='height'; break; case 'CITY': $tablec='city'; break; case 'TALENT': $tablec='talent_skills'; break; case 'BUILD': $tablec='body_built'; break; case 'LOOKS': $tablec='talent_skills'; break; case 'ROLE': $tablec='talent_skills'; break; case 'TALENT_B': $tablec='talent_skills'; break; } switch($d){ case 'WORKSHOP': $tabled='workshop'; break; case 'AGE': $tabled='age'; break; case 'BIRTHDATE': $tabled='birthdate'; break; case 'COURSE': $tabled='course'; break; case 'GENDER': $tabled='gender'; break; case 'NATIONALITY': $tabled='nationality'; break; case 'HEIGHT': $tabled='height'; break; case 'WEIGHT': $tabled='height'; break; case 'CITY': $tabled='city'; break; case 'TALENT': $tabled='talent_skills'; break; case 'BUILD': $tabled='body_built'; break; case 'LOOKS': $tabled='talent_skills'; break; case 'ROLE': $tabled='talent_skills'; break; case 'TALENT_B': $tabled='talent_skills'; break; } switch($e){ case 'WORKSHOP': $tablee='workshop'; break; case 'AGE': $tablee='age'; break; case 'BIRTHDATE': $tablee='birthdate'; break; case 'COURSE': $tablee='course'; break; case 'GENDER': $tablee='gender'; break; case 'NATIONALITY': $tablee='nationality'; break; case 'HEIGHT': $tablee='height'; break; case 'WEIGHT': $tablee='height'; break; case 'CITY': $tablee='city'; break; case 'TALENT': $tablee='talent_skills'; break; case 'BUILD': $tablee='body_built'; break; case 'LOOKS': $tablee='talent_skills'; break; case 'ROLE': $tablee='talent_skills'; break; case 'TALENT_B': $tablee='talent_skills'; break; } switch($f){ case 'WORKSHOP': $tablef='workshop'; break; case 'AGE': $tablef='age'; break; case 'BIRTHDATE': $tablef='birthdate'; break; case 'COURSE': $tablef='course'; break; case 'GENDER': $tablef='gender'; break; case 'NATIONALITY': $tablef='nationality'; break; case 'HEIGHT': $tablef='height'; break; case 'WEIGHT': $tablef='height'; break; case 'CITY': $tablef='city'; break; case 'TALENT': $tablef='talent_skills'; break; case 'BUILD': $tablef='body_built'; break; case 'LOOKS': $tablef='talent_skills'; break; case 'ROLE': $tablef='talent_skills'; break; case 'TALENT_B': $tablef='talent_skills'; break; } switch($g){ case 'WORKSHOP': $tableg='workshop'; break; case 'AGE': $tableg='age'; break; case 'BIRTHDATE': $tableg='birthdate'; break; case 'COURSE': $tableg='course'; break; case 'GENDER': $tableg='gender'; break; case 'NATIONALITY': $tableg='nationality'; break; case 'HEIGHT': $tableg='height'; break; case 'WEIGHT': $tableg='height'; break; case 'CITY': $tableg='city'; break; case 'TALENT': $tableg='talent_skills'; break; case 'BUILD': $tableg='body_built'; break; case 'LOOKS': $tableg='talent_skills'; break; case 'ROLE': $tableg='talent_skills'; break; case 'TALENT_B': $tableg='talent_skills'; break; } switch($h){ case 'WORKSHOP': $tableh='workshop'; break; case 'AGE': $tableh='age'; break; case 'BIRTHDATE': $tableh='birthdate'; break; case 'COURSE': $tableh='course'; break; case 'GENDER': $tableh='gender'; break; case 'NATIONALITY': $tableh='nationality'; break; case 'HEIGHT': $tableh='height'; break; case 'WEIGHT': $tableh='height'; break; case 'CITY': $tableh='city'; break; case 'TALENT': $tableh='talent_skills'; break; case 'BUILD': $tableh='body_built'; break; case 'LOOKS': $tableh='talent_skills'; break; case 'ROLE': $tableh='talent_skills'; break; case 'TALENT_B': $tableh='talent_skills'; break; } switch($i){ case 'WORKSHOP': $tablei='workshop'; break; case 'AGE': $tablei='age'; break; case 'BIRTHDATE': $tablei='birthdate'; break; case 'COURSE': $tablei='course'; break; case 'GENDER': $tablei='gender'; break; case 'NATIONALITY': $tablei='nationality'; break; case 'HEIGHT': $tablei='height'; break; case 'WEIGHT': $tablei='height'; break; case 'CITY': $tablei='city'; break; case 'TALENT': $tablei='talent_skills'; break; case 'BUILD': $tablei='body_built'; break; case 'LOOKS': $tablei='talent_skills'; break; case 'ROLE': $tablei='talent_skills'; break; case 'TALENT_B': $tablei='talent_skills'; break; } switch($j){ case 'WORKSHOP': $tablej='workshop'; break; case 'AGE': $tablej='age'; break; case 'BIRTHDATE': $tablej='birthdate'; break; case 'COURSE': $tablej='course'; break; case 'GENDER': $tablej='gender'; break; case 'NATIONALITY': $tablej='nationality'; break; case 'HEIGHT': $tablej='height'; break; case 'WEIGHT': $tablej='height'; break; case 'CITY': $tablej='city'; break; case 'TALENT': $tablej='talent_skills'; break; case 'BUILD': $tablej='body_built'; break; case 'LOOKS': $tablej='talent_skills'; break; case 'ROLE': $tablej='talent_skills'; break; case 'TALENT_B': $tablej='talent_skills'; break; } switch($k){ case 'WORKSHOP': $tablek='workshop'; break; case 'AGE': $tablek='age'; break; case 'BIRTHDATE': $tablek='birthdate'; break; case 'COURSE': $tablek='course'; break; case 'GENDER': $tablek='gender'; break; case 'NATIONALITY': $tablek='nationality'; break; case 'HEIGHT': $tablek='height'; break; case 'WEIGHT': $tablek='height'; break; case 'CITY': $tablek='city'; break; case 'TALENT': $tablek='talent_skills'; break; case 'BUILD': $tablek='body_built'; break; case 'LOOKS': $tablek='talent_skills'; break; case 'ROLE': $tablek='talent_skills'; break; case 'TALENT_B': $tablek='talent_skills'; break; } switch($l){ case 'WORKSHOP': $tablel='workshop'; break; case 'AGE': $tablel='age'; break; case 'BIRTHDATE': $tablel='birthdate'; break; case 'COURSE': $tablel='course'; break; case 'GENDER': $tablel='gender'; break; case 'NATIONALITY': $tablel='nationality'; break; case 'HEIGHT': $tablel='height'; break; case 'WEIGHT': $tablel='height'; break; case 'CITY': $tablel='city'; break; case 'TALENT': $tablel='talent_skills'; break; case 'BUILD': $tablel='body_built'; break; case 'LOOKS': $tablel='talent_skills'; break; case 'ROLE': $tablel='talent_skills'; break; case 'TALENT_B': $tablel='talent_skills'; break; } switch($x){ case 'a': if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA = $value[1]; $searchValueAA = $value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else { $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' ORDER BY `lname` ASC"); } break; //======================================================================================================================== case 'b': if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'c': if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tableb` LIKE '%$bb%' AND `$tablea` LIKE '%$aa%' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%'' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'd': if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =STRTOUPPER($value[1]); $searchValueDD =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled`LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND `$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%'' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'e': if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =STRTOUPPER($value[1]); $searchValueEE =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[1]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` = '$ee' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$dd%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablec` LIKE '%$cc%' AND`$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` BETWEEN '$searchValueD' AND `$searchValueDD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'f': if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =STRTOUPPER($value[1]); $searchValueFF =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$aa' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tabled` LIKE '%$dd%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablea` LIKE '%$aa%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` < '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` > '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$searchValueD' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$dd%' AND `$tablea` LIKE '%$aa%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablec` LIKE '%$cc%' AND `$tableb` LIKE '%$bb%' AND `$tablea` = '$aa' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status` = '1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'g': if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =STRTOUPPER($value[1]); $searchValueGG =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` < '$searchValueG' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` > '$searchValueG' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec`LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$searchValueG' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` < '$searchValueA' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` > '$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef`LIKE '%$ff%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$gg%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'h': if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =STRTOUPPER($value[1]); $searchValueHH =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND`$tableg` LIKE '%$gg%' AND AND `$tableh` < '$searchValueH' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee`LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND AND `$tableh` > '$searchValueH' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND AND `$tableh` = '$searchValueH' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` < '$searchValueA' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` > '$searchValueA' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` = '$searchValueA' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` LIKE '%$hh%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` < '$searchValueB' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` > '$searchValueB' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` = '$searchValueB' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` < '$searchValueC' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` > '$searchValueC' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` = '$searchValueC' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` < '$searchValueD' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` > '$searchValueD' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` = '$searchValueD' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` < '$searchValueE' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` > '$searchValueE' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` = '$searchValueE' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg`LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg`LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` < '$searchValueG' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` > '$searchValueG' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee`LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$searchValueG' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` LIKE '%$gg%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh`LIKE '%$hh%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'i': if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =STRTOUPPER($value[1]); $searchValueII =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$searchValueI' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$searchValueI' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$searchValueI' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` BETWEEN '$searchValueI' AND '&searchValueII' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$ii' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$ii' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$ii' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$hh%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` < '$ii' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` > '$ii' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` = '$ii' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'j': if($j==='AGE'){ $value = explode('+',$jj); $operator = STRTOUPPER($value[0]); $searchValueI =STRTOUPPER($value[1]); $searchValueII =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND`$tablej` < '$searchValueI' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` > '$searchValueI' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` = '$searchValueI' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` BETWEEN '$searchValueI' AND '&searchValueII' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `$tablei` LIKE '%$hh%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =$value[1]; $searchValueII =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablei` BETWEEN '$searchValueI' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== case 'k': if($k==='AGE'){ $value = explode('+',$kk); $operator = STRTOUPPER($value[0]); $searchValueK =STRTOUPPER($value[1]); $searchValueKK =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` < '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` > '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` = '$searchValueK' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` BETWEEN '$searchValueK' AND '&searchValueII' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` < '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` > '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` = '$searchValueA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` BETWEEN '$searchValueA' AND '$searchValueAA' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$ee%' AND `$tablee`LIKE '%$ff%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `$tablei` LIKE '%$hh%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableb` BETWEEN '$searchValueB' AND '$searchValueBB' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` < '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` > '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` = '$searchValueC' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablec` BETWEEN '$searchValueC' AND '$searchValueCC' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$gg%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` < '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` > '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` = '$searchValueD' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tabled` BETWEEN '$searchValueD' AND '$searchValueDD' AND `$tablea` LIKE '%$aa%' AND `$tableb` = '$bb' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` AND `tablek` LIKE '%$kk%' LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` < '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` > '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$searchValueE' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablee` BETWEEN '$searchValueE' AND '$searchValueEE' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$cc%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` = '$ff' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` < '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` > '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` = '$searchValueF' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablef` BETWEEN '$searchValueF' AND '$searchValueFF' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` = '$dd' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` < '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` > '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableg` = '$searchValueG' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableg` BETWEEN '$searchValueG' AND '$searchValueGG' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$ee%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` < '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` > '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tableh` = '$searchValueH' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tableh` BETWEEN '$searchValueH' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =$value[1]; $searchValueII =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablei` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablei` BETWEEN '$searchValueI' AND '$searchValueHH' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablej` LIKE '%$jj%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else if($j==='AGE'){ $value = explode('+',$jj); $operator = STRTOUPPER($value[0]); $searchValueJ =$value[1]; $searchValueJJ =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` < '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` > '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablej` = '$searchValueI' AND `$tabled` LIKE '%$dd%' AND `$tablee` = '$ee' AND `$tablef` LIKE '%$ff%' AND `$tableg` = '$gg' AND `$tablec` LIKE '%$cc%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablej` BETWEEN '$searchValueJ' AND '$searchValueJJ' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%'' AND `$tableg` LIKE '%$gg%' AND `$tablee` LIKE '%$ee%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `$tablek` LIKE '%$kk%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== //======================================================================================================================== case 'l': if($l==='AGE'){ $value = explode('+',$ll); $operator = STRTOUPPER($value[0]); $searchValueL =STRTOUPPER($value[1]); $searchValueLL =STRTOUPPER($value[2]); switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` LIKE '%$kk%' AND `$tablel` < '$searchValueL' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` LIKE '%$kk%' AND `$tablel` > '$searchValueL' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea`LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` LIKE '%$kk%' AND `$tablel` = '$searchValueL' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablek` LIKE '%$kk%' AND `$tablel` BETWEEN '$searchValueL' AND '&searchValueLL' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else { if($a==='AGE'){ $value = explode('+',$aa); $operator = STRTOUPPER($value[0]); $searchValueA =$value[1]; $searchValueAA =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablea` < '$searchValueA' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablea` > '$searchValueA' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablea` = '$searchValueA' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablea` BETWEEN '$searchValueA' AND '&searchValueAA' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($b==='AGE'){ $value = explode('+',$bb); $operator = STRTOUPPER($value[0]); $searchValueB =$value[1]; $searchValueBB =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableb` < '$searchValueB' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableb` > '$searchValueB' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableb` = '$searchValueB' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableb` BETWEEN '$searchValueB' AND '&searchValueBB' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($c==='AGE'){ $value = explode('+',$cc); $operator = STRTOUPPER($value[0]); $searchValueC =$value[1]; $searchValueCC =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablec` < '$searchValueC' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablec` > '$searchValueC' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablec` = '$searchValueC' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablec` BETWEEN '$searchValueC' AND '&searchValueCC' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($d==='AGE'){ $value = explode('+',$dd); $operator = STRTOUPPER($value[0]); $searchValueD =$value[1]; $searchValueDD =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tabled` < '$searchValueD' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tabled` > '$searchValueD' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tabled` = '$searchValueD' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tabled` BETWEEN '$searchValueD' AND '&searchValueDD' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } } else if($e==='AGE'){ $value = explode('+',$ee); $operator = STRTOUPPER($value[0]); $searchValueE =$value[1]; $searchValueEE =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablee` < '$searchValueE' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablee` > '$searchValueE' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablee` = '$searchValueE' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablee` BETWEEN '$searchValueE' AND '&searchValueEE' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($f==='AGE'){ $value = explode('+',$ff); $operator = STRTOUPPER($value[0]); $searchValueF =$value[1]; $searchValueFF =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablef` < '$searchValueF' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablef` > '$searchValueF' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablef` = '$searchValueF' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tablef` BETWEEN '$searchValueF' AND '&searchValueFF' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($g==='AGE'){ $value = explode('+',$gg); $operator = STRTOUPPER($value[0]); $searchValueG =$value[1]; $searchValueGG =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableg` < '$searchValueG' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableg` > '$searchValueG' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableg` = '$searchValueG' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableg` BETWEEN '$searchValueG' AND '&searchValueGG' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($h==='AGE'){ $value = explode('+',$hh); $operator = STRTOUPPER($value[0]); $searchValueH =$value[1]; $searchValueHH =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableh` < '$searchValueH' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableh` > '$searchValueH' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableh` = '$searchValueH' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tablei` LIKE '%$ii%' AND `$tablel` LIKE '%$aa%' AND `$tableh` BETWEEN '$searchValueH' AND '&searchValueHH' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($i==='AGE'){ $value = explode('+',$ii); $operator = STRTOUPPER($value[0]); $searchValueI =$value[1]; $searchValueII =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablei` < '$searchValueI' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablei` > '$searchValueI' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablei` = '$searchValueI' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablei` BETWEEN '$searchValueI' AND '&searchValueII' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else if($j==='AGE'){ $value = explode('+',$jj); $operator = STRTOUPPER($value[0]); $searchValueJ =$value[1]; $searchValueJJ =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablej` < '$searchValueJ' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablej` > '$searchValueJ' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablej` = '$searchValueJ' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablej` BETWEEN '$searchValueJ' AND '&searchValueJJ' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; } }else if($K==='AGE'){ $value = explode('+',$KK); $operator = STRTOUPPER($value[0]); $searchValueK =$value[1]; $searchValueKK =$value[2]; switch($operator){ case 'LESS': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablek` < '$searchValueK' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'ABOVE': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablek` > '$searchValueK' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'EQUAL': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek`LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablek` = '$searchValueK' AND `tablei` LIKE '%$ii%' ORDER BY `lname` ASC"); break; case 'BETWEEN': $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablek` LIKE '%$kk%' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablel` LIKE '%$aa%' AND `$tablek` BETWEEN '$searchValueK' AND '&searchValueKH' AND `tablei` LIKE '%$ii%' AND `tablej` LIKE '%$jj%' ORDER BY `lname` ASC"); break; } }else{ $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `$tablea` LIKE '%$aa%' AND `$tableb` LIKE '%$bb%' AND `$tablec` LIKE '%$cc%' AND `$tabled` LIKE '%$dd%' AND `$tablee` LIKE '%$ee%' AND `$tablef` LIKE '%$ff%' AND `$tableg` LIKE '%$gg%' AND `$tableh` LIKE '%$hh%' AND `$tablei` LIKE '%$ii%' AND `$tablej` LIKE '%$jj%' AND `$tablek` LIKE '%$kk%' AND `$tablel` LIKE '%$ll%' ORDER BY `lname` ASC"); } } break; //======================================================================================================================== } echo "<div STYLE='height: 400px; width: 100%; font-size: 12px; overflow: auto;'>"; 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'); $id =$row['id']; $profilePic = mysql_result(mysql_query("SELECT `file_code` FROM `tb_images` WHERE `talent_id`='$id'"),0); //echo "My Age: ".$newAge; echo "<ABBR title='".$row['talent_skills']."'><div style='margin:5px;float:left;width:22%;height:175px;min-width:200px;border:1px solid lightgray;border-radius:5px;padding:5px;box-shadow:5px 5px 8px lightgray;background:white'>"; echo "<table style='width:100%;height:100%'>"; echo "<tr>"; echo "<td colspan='2' style='width:100%;border:1px solid lightgray;' valign='top'>"; echo "<h3 class='lightGradient' style='height:15px;padding:3px;font-family:Calibri;font-size:12px;font-weight:bold'> <a href='main_new.php?view=100&sview=911&sid=UR&search=&view=plist&id=".$id."&tab=0#id-0'> ".$row['lname'].",".$row['fname']."</a></h3>"; echo"</td>"; echo "</tr>"; echo "<tr>"; echo "<td style='background:white;border-radius:3px;height:100%;width:50%;border:1px solid lightgray;background-image:url(\"talentImages/".$profilePic."\");background-size:50%;background-repeat:no-repeat;background-position:auto;background-size:100%'></td>"; echo "<td style='height:100%;width:50%;border:1px solid lightgray;' valign='top'>"; echo "<h4 style='border:0px;font-family:Calibri;font-size:10px;font-weight:normal;color:gray'>AGE: <b style='font-size:10px;color:black'>".$row['age']."</b></h4>"; echo "<h4 style='border:0px;font-family:Calibri;font-size:10px;font-weight:normal;color:gray'>GENDER: <b style='font-size:10px;color:black'>".$row['gender']."</b></h4>"; echo "<h4 style='border:0px;font-family:Calibri;font-size:10px;font-weight:normal;color:gray'>NATIONALITY: <b style='font-size:10px;color:black'>".$row['nationality']."</b></h4>"; echo "<h4 style='border:0px;font-family:Calibri;font-size:10px;font-weight:normal;color:gray'>HEIGHT: <b style='font-size:10px;color:black'>".$row['height']."</b> cm </h4>"; echo "<h4 style='border:0px;font-family:Calibri;font-size:10px;font-weight:normal;color:gray'>WEIGHT: <b style='font-size:10px;color:black'>".$row['weight']." </b>lbs</h4>"; echo "<h4 style='border:0px;font-family:Calibri;font-size:10px;font-weight:normal;color:gray'>EYES: <b style='font-size:10px;color:black'>".$row['eyes']."</b></h4>"; echo "<h4 style='border:0px;font-family:Calibri;font-size:10px;font-weight:normal;color:gray'>HAIR: <b style='font-size:10px;color:black'>".$row['hair']."</b></h4>"; echo "<h4 style='border:0px;font-family:Calibri;font-size:10px;font-weight:normal;color:gray'> <form action='' method='POST'> <input type='hidden' name='id' value='".$row['id']."'> <input type='submit' name='playVTR' value='PLAY VTR' style='height:18px;font-family:Calibri;font-size:10px;font-weight:bold;border:1px solid white;border-radius:5px'> </form> </h4>"; echo "<h4 align='left' style='margin-top:2px;border:0px;font-family:Calibri;font-size:10px;font-weight:bold;color:blue'>Ratings:<br><center><b style='font-size:16px;color:red'>".number_format($row['scores'],1,'.',',')."</b></h4></center>"; echo"</td>"; echo "</tr>"; echo "</table>"; echo "</div></ABBR>"; } echo "</div>"; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings