session_start(); include("settings.php"); define("TITLE", "Christian Polygyny - Personals"); include("header.php"); $criteria = $HTTP_GET_VARS['searchfor']; $value = $HTTP_GET_VARS['searchquery']; if ($HTTP_GET_VARS["go"]=="all" && $_SESSION['currentuser']!=""){ thesearch(); mysql_connect("localhost", "$USERNAME", "$PASSWORD") or die(mysql_error()); mysql_select_db("marinetw_memberdatabase") or die(mysql_error()); $result = mysql_query("SELECT id, Blocked, displayname, age, gender, location, country, personals FROM members WHERE personals='Yes'"); $personalcounter = "1"; echo "
";
while($row = mysql_fetch_array($result)){
if ($row['Blocked'] == "No"){
$idvalue = $row['id'];
echo "".$row['displayname']." "; echo $row['age']." years old, ".$row['gender']." ".$row['location']." ".$row['country'].""; if($personalcounter == "2"){ echo " | |
"; $personalcounter = "1"; }else{ echo " | "; $personalcounter = $personalcounter +1; } } } echo " |
"; while($row = mysql_fetch_array($result)){ $idvalue = $row['id']; echo "".$row['displayname']." | "; echo $row['age'].", ".$row['gender']." - ".$row['location']." ".$row['country']." |
"; } if(!$result){ echo "No Records Found"; } // $result = mysql_query("SELECT id, displayname, age, gender, location, country FROM members WHERE displayname='$value' AND personals='Yes'"); // while($row = mysql_fetch_array( $result )){ // $idvalue = $row['id']; // echo "".$row['displayname']." | "; // echo $row['age'].", ".$row['gender']." - ".$row['location']." ".$row['country']." |
"; // } echo " |