<?php
include "general.php";
include "onlineupdate.php";
include "photoupdate.php";


$country = $_POST['country'];
$sex =$_POST['sex'];
$age =$_POST['age'];

//$query2 ="SELECT nickname,profile,online,palid FROM Penpalsubscriber where photo ='1' and palid !='".$_SESSION['palid'] ."' and country ='$country' and sex ='$sex' and age ='$age' order by sn desc  limit 100";

$query = $db->prepare("SELECT nickname,profile,online,palid FROM Penpalsubscriber where photo ='1' and palid !='".$_SESSION['palid'] ."' and country ='$country' and sex ='$sex' and age ='$age' order by sn desc  limit 100") ;
$query->execute();

//Fetch
$cnt1 = 0;
while ($fetch = $query->fetch(PDO::FETCH_ASSOC))
{
$nicknameother =$fetch['nickname'];
$profileother =$fetch['profile'];
$palidother =$fetch['palid'];
$onlinepals =$fetch['online'];



echo  "<br><span class='left clearfix'>
<span class='chat-img pull-left'>
<img src='assets/img/subscribers/$palidother/profile/$palidother.jpg' alt='User Avatar' class='img-circle' />
</span>
<div class='chat-body clearfix'>
<div class='header'>
<a href='onlineprofile.php?id=". $palidother ."'><strong class='primary-font '> ".ucwords($nicknameother)." </strong></a>
    <br />
   <p>
       ".ucwords($profileother)."
   </p>

    <small class='pull-left text-muted'>";

          if ($onlinepals =='1')
          echo " <a class='btn btn-success btn-xs btn-circle' style='width: 10px;height: 12px;'></a> Online";
          else
            echo " <a class='btn btn-warning btn-xs btn-circle' style='width: 10px;height: 12px;'></a> Offline";


echo           "   </small></div></div></span>";


$cnt1++;
}

if ($cnt1 ==0)
 echo "<br><p style='color:red'>Sorry, no record found. Kindly change your criteria and try again</p>"

//echo $query2;
?>