prefix("friendfinder")." inner join ".$db->prefix("friendfinder_state")." on state = cid WHERE (DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS($dat)), '%Y')+0) BETWEEN $agefrom AND $agetill AND partner='$sex' AND sex='$partner' AND state='$state' AND active='1' AND category='$category' ORDER BY '$sort'"; } else { echo ""._TEXTSEARCHUNSUCCESSFUL.""; } echo "
"; $result = $db->query($sql); while (list($id,$user,$city,$state,$birth,$title ) = $db->fetchRow($result)) { echo "
"; } echo "

"._UNAME."	"._TEXTREGION."	"._CITY."	"._TEXTAGE."
makeTboxData4Show($id).">".$myts->makeTboxData4Show($user)."	".$myts->makeTboxData4Show($title)."	".$myts->makeTboxData4Show($city)."	".getage($birth)."

"; //echo "No Results found"; } else { echo"

"._TEXTSEX."	"; list($numrows) = $db->fetchRow($db->query("select sid, sextitle from ".$db->prefix("friendfinder_sex")."")); if ($numrows>0) { $result = $db->query("select sid, sextitle from ".$db->prefix("friendfinder_sex")." order by sextitle"); echo ""._CLA_SELECTCAT.""; while(list($sid, $sextitle) = $db->fetchRow($result)) { echo "$sextitle"; } } echo"
"._TEXTPSEX."	"; list($numrows) = $db->fetchRow($db->query("select sid, sextitle from ".$db->prefix("friendfinder_sex")."")); if ($numrows>0) { $result = $db->query("select sid, sextitle from ".$db->prefix("friendfinder_sex")." order by sextitle"); echo ""._CLA_SELECTCAT.""; while(list($sid, $sextitle) = $db->fetchRow($result)) { echo "$sextitle"; } } echo"
"._TEXTAGE."	"._AGEFROM." "._AGETILL."
"._CATEGORY.':'."	"; list($numrows) = $db->fetchRow($db->query("select catid, cattitle from ".$db->prefix("friendfinder_category")."")); if ($numrows>0) { $result = $db->query("select catid, cattitle from ".$db->prefix("friendfinder_category")." order by cattitle"); echo ""._CLA_SELECTCAT.""; while(list($catid, $cattitle) = $db->fetchRow($result)) { echo "$cattitle"; } } echo"
"._TEXTREGION."	"; list($numrows) = $db->fetchRow($db->query("select cid, title from ".$db->prefix("friendfinder_state")."")); if ($numrows>0) { $result = $db->query("select cid, title from ".$db->prefix("friendfinder_state")." order by title"); echo""._CLA_SELECTCAT.""; while(list($cid, $title) = $db->fetchRow($result)) { echo "$title"; } } echo"
"._TEXTSEARCHSORT."	"._SELECTSORT."

"; } //include "admin/foot.php"; //************************************************************ CloseTable(); include_once("../../footer.php"); ?>