= $age and age <= $age2)"; $request.="&age=".urlencode($age)."&age2=".urlencode($age2); }else if($age!=""){ $age=intval($age); if($rest!="")$rest.=" $o1 "; $rest.="age >= $age"; $request.="&age=".urlencode($age); }else if($age2!=""){ $age2=intval($age2); if($rest!="")$rest.=" $o1 "; $rest.="age <= $age2"; $request.="&age2=".urlencode($age2); } if($race!="") { if($rest=="") { if ($race=="Other") { $rest.=" race not in('chinese', 'indian', 'malay') "; } else { $rest.="race= '$race'"; } } else { if ($race=="Other") { $rest.=" $o1 race not in('chinese', 'indian', 'malay') "; } else { $rest.=" $o1 race= '$race' "; } } $request.="&race=".urlencode($race); } if($nationality!="") { if($rest=="") { $rest.="nationality= '$nationality'"; } else { $rest.=" $o1 nationality= '$nationality' "; } $request.="&nationality=".urlencode($nationality); } if($gender!="") { if($rest=="") { $rest.="gender= '$gender'"; } else { $rest.=" $o1 gender= '$gender' "; } $request.="&gender=".urlencode($gender); } if($marital!="") { if($rest=="") { $rest.="marital= '$marital'"; } else { $rest.=" $o1 marital= '$marital' "; } $request.="&marital=".urlencode($marital); } if($height!="" && $height2!="") { if($rest!="")$rest.=" $o1 "; $rest.="(height >= '$height' and height <= '$height2')"; $request.="&height=".urlencode($height)."&height2=".urlencode($height2); }else if($height!="") { if($rest!="")$rest.=" $o1 "; $rest.="height >= '$height'"; $request.="&height=".urlencode($height); }else if($height2!="") { if($rest!="")$rest.=" $o1 "; $rest.="height <= '$height2'"; $request.="&height2=".urlencode($height2); } if($weight!="" && $weight2!=""){ if($rest!="")$rest.=" $o1 "; $rest.="(weight >= '$weight' and weight <= '$weight2')"; $request.="&weight=".urlencode($weight)."&weight2=".urlencode($weight2); }else if($weight!=""){ if($rest!="")$rest.=" $o1 "; $rest.="weight >= '$weight'"; $request.="&weight=".urlencode($weight); }else if($weight2!=""){ if($rest!="")$rest.=" $o1 "; $rest.="weight <= '$weight2'"; $request.="&weight2=".urlencode($weight2); } if($dresssize!="") { if($rest=="") { $rest.="dresssize= '$dresssize'"; } else { $rest.=" $o1 dresssize= '$dresssize' "; } $request.="&dresssize=".urlencode($dresssize); } if($shoesize!="" && $shoesize2!="") { if($rest!="")$rest.=" $o1 "; $rest.="(shoesize >= '$shoesize' and shoesize <= '$shoesize2')"; $request.="&shoesize=".urlencode($shoesize)."&shoesize2=".urlencode($shoesize); }else if($shoesize!="") { if($rest!="")$rest.=" $o1 "; $rest.="shoesize >= '$shoesize'"; $request.="&shoesize=".urlencode($shoesize); }else if($shoesize2!="") { if($rest!="")$rest.=" $o1 "; $rest.="shoesize <= '$shoesize2'"; $request.="&shoesize2=".urlencode($shoesize); } if($hair!="") { if($rest=="") { $rest.="hair= '$hair'"; } else { $rest.=" $o1 hair= '$hair' "; } $request.="&hair=".urlencode($hair); } if($haircolor!="") { if($rest=="") { $rest.="haircolor= '$haircolor'"; } else { $rest.=" $o1 haircolor= '$haircolor' "; } $request.="&haircolor=".urlencode($haircolor); } if($eyescolor!="") { if($rest=="") { $rest.="eyescolor= '$eyescolor'"; } else { $rest.=" $o1 eyescolor= '$eyescolor' "; } $request.="&eyescolor=".urlencode($eyescolor); } if($bust!="" && $bust2!="") { if($rest!="")$rest.=" $o1 "; $rest.="(bust >= '$bust' and bust <= '$bust2')"; $request.="&bust=".urlencode($bust)."&bust2=".urlencode($bust2); }else if($bust!="") { if($rest!="")$rest.=" $o1 "; $rest.="bust >= '$bust'"; $request.="&bust=".urlencode($bust); }else if($bust2!="") { if($rest!="")$rest.=" $o1 "; $rest.="bust <= '$bust2'"; $request.="&bust2=".urlencode($bust2); } if($cup!="") { if($rest=="") { $rest.="cup= '$cup'"; } else { $rest.=" $o1 cup= '$cup' "; } $request.="&cup=".urlencode($cup); } if($waist!="" && $waist2!="") { if($rest!="")$rest.=" $o1 "; $rest.="(waist >= '$waist' and waist <= '$waist2')"; $request.="&waist=".urlencode($waist)."&waist2=".urlencode($waist2); }else if($waist!="") { if($rest!="")$rest.=" $o1 "; $rest.="waist >= '$waist'"; $request.="&waist=".urlencode($waist); }else if($waist2!="") { if($rest!="")$rest.=" $o1 "; $rest.="waist <= '$waist2'"; $request.="&waist2=".urlencode($waist2); } if($hip!="" && $hip2!="") { if($rest!="")$rest.=" $o1 "; $rest.="(hip >= '$hip' and hip <= '$hip2')"; $request.="&hip=".urlencode($hip)."&hip2=".urlencode($hip2); }if($hip!="") { if($rest!="")$rest.=" $o1 "; $rest.="hip >= '$hip'"; $request.="&hip=".urlencode($hip); }if($hip2!="") { if($rest!="")$rest.=" $o1 "; $rest.="hip <= '$hip2'"; $request.="&hip2=".urlencode($hip2); } if($occupation!="") { if($rest=="") { $rest.="occupation= '$occupation' "; } else { $rest.=" $o1 occupation= '$occupation' "; } $request.="&occupation=".urlencode($occupation); } if($lang!="") { if($rest=="") { $rest.="lang= '$lang'"; } else { $rest.=" $o1 lang= '$lang' "; } $request.="&lang=".urlencode($lang); } if($lang1!="") { if($rest=="") { $rest.="lang1= '$lang1'"; } else { $rest.=" $o1 lang1= '$lang1' "; } $request.="&lang1=".urlencode($lang1); } if($monday!="") { if($rest3=="") { $rest3.="monday= '$monday'"; } else { $rest3.=" $o2 monday= '$monday' "; } $request.="&monday=".urlencode($monday); } if($tuesday!="") { if($rest3=="") { $rest3.="tuesday= '$tuesday'"; } else { $rest3.=" $o2 tuesday= '$tuesday' "; } $request.="&tuesday=".urlencode($tuesday); } if($wednesday!="") { if($rest3=="") { $rest3.="wednesday= '$wednesday'"; //$text.="Wednesday= $wednesday"; } else { $rest3.=" $o2 wednesday= '$wednesday' "; } $request.="&wednesday=".urlencode($wednesday); } if($thursday!="") { if($rest3=="") { $rest3.="thursday= '$thursday'"; } else { $rest3.=" $o2 thursday= '$thursday' "; } $request.="&thursday=".urlencode($thursday); } if($friday!="") { if($rest3=="") { $rest3.="friday= '$friday'"; } else { $rest3.=" $o2 friday= '$friday' "; } $request.="&friday=".urlencode($friday); } if($saturday!="") { if($rest3=="") { $rest3.="saturday= '$saturday'"; } else { $rest3.=" $o2 saturday= '$saturday' "; } $request.="&saturday=".urlencode($saturday); } if($sunday!="") { if($rest3=="") { $rest3.="sunday= '$sunday'"; } else { $rest3.=" $o2 sunday= '$sunday' "; //$text.=", Sunday = $sunday"; } $request.="&sunday=".urlencode($sunday); } if($otherstate!="") { if($rest3=="") { $rest3.="otherstate= '$otherstate'"; //$text.=" Other state= $otherstate"; } else { $rest3.=" $o2 otherstate= '$otherstate' "; //$text.=", Other state = $otherstate"; } $request.="&otherstate=".urlencode($otherstate); } if($othercity!="") { if($rest3=="") { $rest3.="otherarea like '%$othercity%'"; //$text.=" Other city= $othercity"; } else { $rest3.=" $o2 otherarea like '%$othercity%' "; //$text.=", Other city = $othercity"; } $request.="&othercity=".urlencode($othercity); } if($otherstate2!="") { if($rest3=="") { $rest3.="otherstate2= '$otherstate2'"; //$text.=" Other state= $otherstate2"; } else { $rest3.=" $o2 otherstate2= '$otherstate2' "; //$text.=", Other state = $otherstate2"; } $request.="&otherstate2=".urlencode($otherstate2); } if($othercity2!="") { if($rest3=="") { $rest3.="otherarea2 like '%$othercity2%'"; //$text.=" Other city= $othercity2"; } else { $rest3.=" $o2 otherarea2 like '%$othercity2%' "; //$text.=", Other city = $othercity2"; } $request.="&othercity2=".urlencode($othercity2); } if($otherstate3!="") { if($rest3=="") { $rest3.="otherstate3= '$otherstate3'"; //$text.=" Other state= $otherstate3"; } else { $rest3.=" $o2 otherstate3= '$otherstate3' "; //$text.=", Other state = $otherstate3"; } $request.="&otherstate3=".urlencode($otherstate3); } if($othercity3!="") { if($rest3=="") { $rest3.="otherarea3 like '%$othercity3%'"; //$text.=" Other city= $othercity3"; } else { $rest3.=" $o2 otherarea3 like '%$othercity3%' "; //$text.=", Other city = $othercity3"; } $request.="&othercity3=".urlencode($othercity3); } for ($i=0;$i<$kira2;$i++) { if($model[$i]!="") { if($rest3=="") { $rest3.=" model like '$model[$i]%'"; //$text.=" Modelling like $model[$i]"; } else { $rest3.=" $o2 model like '$model[$i]%'"; //$text.=" Modelling like $model[$i]"; } $request.="&model[]=".urlencode($model[$i]); } } for ($i=0;$i<$kira3;$i++) { if($shows[$i]!="") { if($rest3=="") { $rest3.=" shows = '$shows[$i]'"; //$text.=" showss like $model[$i]"; } else { $rest3.=" $o2 shows like '$shows[$i]%'"; //$text.=" showss like $shows[$i]"; } } $request.="&shows=".urlencode($shows); } for ($i=0;$i<$kira4;$i++) { if($promoter[$i]!="") { if($rest3=="") { $rest3.=" promoter like '$promoter[$i]%'"; //$text.=" Promoter like $promoter[$i]"; } else { $rest3.=" $o2 promoter like '$promoter[$i]%'"; //$text.=" Promoter like $promoter[$i]"; } } $request.="&promoter[]=".urlencode($promoter[$i]); } if($SalaryDay!="") { if($rest3=="") { $rest3.=" SalaryDay = '$SalaryDay'"; //$text.=" SalaryDay = $SalaryDay"; } else { $rest3.=" $o SalaryDay like '$SalaryDay'"; //$text.=" SalaryDay like $SalaryDay"; } $request.="&salaryday=".urlencode($SalaryDay); } if($SalaryHour!="") { if($rest3=="") { $rest3.=" SalaryHour = '$SalaryHour' "; //$text.=" SalaryHour = $SalaryHour"; } else { $rest3.=" $o SalaryHour like '$SalaryHour'"; //$text.=" SalaryHour like $SalaryHour"; } $request.="&salaryhour=".urlencode($SalaryHour); } if($outstation!=""){ if($rest3!="")$rest3.=" $o "; $rest3.="outstation = '".$outstation."'"; $request.="&outstation=".urlencode($outstation); } if($_REQUEST["night"]!=""){ if($rest3!="")$rest3.=" $o "; $rest3.=" night = '".$_REQUEST["night"]."'"; $request.="&night=".urlencode($_REQUEST["night"]); } if($_REQUEST["transport"]!=""){ if($rest3!="")$rest3.=" $o "; $rest3.=" transport = '".$_REQUEST["transport"]."'"; $request.="&transport=".urlencode($_REQUEST["transport"]); } if($_REQUEST["sexy"]!=""){ if($rest3!="")$rest3.=" $o "; $rest3.=" sexy = '".$_REQUEST["sexy"]."'"; $request.="&sexy=".urlencode($_REQUEST["sexy"]); } if($_REQUEST["alcohol"]!=""){ if($rest3!="")$rest3.=" $o "; $rest3.=" alcohol = '".$_REQUEST["alcohol"]."'"; $request.="&alcohol=".urlencode($_REQUEST["alcohol"]); } $s= @$HTTP_GET_VARS["s"]; if ($s == ""){$s=0;} $limit=20; $query .= " LIMIT $s,$limit"; //------- search based on distinct email ------ session_start(); $emFinal==" "; if (!empty($_GET["r1"])) $rest = stripslashes($_GET["r1"]); if (!empty($_GET["r2"])) $rest2 = stripslashes($_GET["r2"]); if (!empty($_GET["r3"])) $rest3 = stripslashes($_GET["r3"]); if ($rest!=""){ $_SESSION["rest"]= $rest; $request = "&r1=" . $rest; $qRest = "Select distinct email from signup where " . $rest; $rRest = mysql_query($qRest); while($rows= mysql_fetch_array($rRest)) { if (!stristr($emFinal, $rows['email'])) { if ($emFinal=="") $emFinal = "'" . $rows['email'] . "'"; else $emFinal = $emFinal . " , '". $rows['email'] ."'"; } } } if ($rest2!=""){ $_SESSION["rest2"]= $rest2; $request .= "&r2=" . $rest2; if ($emFinal!=""){ $qRest2 = "Select distinct email from interest where email in(". $emFinal .") AND " . $rest2; $emFinal=""; } else{ $qRest2 = "Select distinct email from interest where " . $rest2; } $rRest2 = mysql_query($qRest2); // reset to obtain new email list based on search criteria while($rows2= mysql_fetch_array($rRest2)) { if (!stristr($emFinal, $rows2['email'])) { if ($emFinal=="") $emFinal ="'". $rows2['email'] ."'"; else $emFinal = $emFinal . " ,'". $rows2['email'] ."'"; } } } if ($rest3!=""){ $_SESSION["rest3"]= $rest3; $request .= "&r3=" . $rest3; if ($emFinal!=""){ $qRest3 = "Select distinct email from jobs where email in (".$emFinal.") AND " . $rest3; $emFinal=""; // reset to obtain new email list based on search criteria } else{ $qRest3 = "Select distinct email from jobs where " . $rest3; } $rRest3 = mysql_query($qRest3); while($rows3= mysql_fetch_array($rRest3)) { if (!stristr($emFinal, $rows3['email'])) { if ($emFinal=="") $emFinal = "'" .$rows3['email']."'" ; else $emFinal = $emFinal . " ,'". $rows3['email'] ."'"; } } } if ($emFinal=="") $emFinal = "'nothing'"; $query2="select sn,email,fullname, glamor, race, age from signup where email in (".$emFinal.") order by rank, sn desc $query"; if ($rest=="" && $rest2=="" && $rest3==""){ $query2="select sn,email,fullname, glamor, race, age from signup where 1=1 order by rank, sn desc $query"; } //------- search based on distinct email end ------ // -------- get search query from url parameter ------- $_SESSION['curPage'] = $s; /*if (!empty($_GET["q"])){ $s_qry = stripslashes($_GET["q"]); $Subqry = explode("LIMIT", $s_qry); $Subqry[1] = $s.",".$limit; $s_qry = implode(" LIMIT ", $Subqry); $_SESSION['qry'] = $s_qry; $result=mysql_query($s_qry,$db) or die(mysql_error()); } else{*/ $_SESSION['qry'] = $query2; $result=mysql_query($query2,$db) or die(mysql_error()); //} $rownumbers=mysql_num_rows($result); ?> Model Galaxies
Model Galaxies

:: Search Result

Back to Search page

Click 'More Info' to see full profile for model/ show girl/ promoter/ supervisor. Click the checkbox to submit your order for selected model/ show girl/ promoter/ supervisor .
 
"; // calculate number of pages needing links $pages=intval($numrows/$limit); // $pages now contains int of pages needed unless there is a remainder from division if (($numrows%$limit)) { // has remainder so add one page $pages++; } // ----- calculate no. of search results ------ if (isset($_SESSION['qry'])) $query2 = $_SESSION['qry']; $Subqry = explode("LIMIT", $query2); $query2 = $Subqry[0]; $result2=mysql_query($query2,$db) or die(mysql_error()); $row=mysql_num_rows($result2); if($row>0){ $paging= ($s+1)."-".($row-$s>=$limit?$s+$limit:$row)." of $row | "; // next we need to do the links to other results if ($s>=1) { // bypass PREV link if s is 0 $prevs=($s-$limit); $paging.= "< prev "; if($prevs>=$limit){ $prevs-=$limit; $paging.= "".((int)($prevs/$limit)+1)." "; } if($s>=1-$limit){ $prevs=$s-$limit; $paging.= "".((int)($prevs/$limit)+1)." "; } } $paging.= ((int)($s/$limit)+1); if($row-$s>$limit){ // not last page so give NEXT link $news=$s+$limit; $paging.= " ".((int)($news/$limit)+1).""; if($row-$news>$limit) $paging.= " ".((int)($news/$limit)+2).""; $paging.= " next >"; } } echo $paging; $a = $s + ($limit) ; if ($a > $rownumbers) { $a = $rownumbers ; } $b = $s + 1 ; ?>
$text"; echo "\n \n \n \n"; $counter=0; while($row=mysql_fetch_array($result)) { $email=$row['email']; $sn=$row['sn']; $fullname=$row['fullname']; $age=$row['age']; $glamor=$row['glamor']; $race=$row['race']; $status=$row['status']; // $pictureId=$row['pictureId']; // $pictures=$row['picture']; $test="("; $test2=")"; $status='Primary'; if($counter>=0) { echo " \n\n\n\n"; $counter=0; } } echo "
Total records found: $row
 \n
 \n
\n \n \n \n \n \n \n \n \n \n
\n \n ID: $sn\n
Age: $age\n
Race: $race\n
More Info
"; $counter++; } if($counter==2) { echo "
  \n
\n"; echo "
$paging
"; ?>
Model Galaxies

Copyright © 2007 Model Galaxies. All Rights Reserved.