$searchquery = "SELECT * FROM userinfo WHERE (fname='{$searchterm1}') AND (lname='{$searchterm2}');";
$searchresult = mysql_query($searchquery) or die("Unable to search DB!");
$numberofresults = mysql_num_rows($searchresult);
if ($numberofresults) {
echo "<h1>Search Results</h1><table id='searchresults' class='searchresults' border=\"1\"><tr>";
while ($row = mysql_fetch_assoc($searchresult)) {
//Get Info about this user
$friendid = $row["userid"];
//Info about user
$fname = $row['fname'];
$lname = $row['lname'];
//Print Table Content
echo "<tr><td><h3><a href='profile.php?id={$friendid}' 'alt='{$fname} {$lname}'s Profile'>{$fname} {$lname}</a></h3></td>";
if (isset($row['city'])) {
echo $row['city'];
echo ", ";
echo $row['state'];
}
echo "<td>";
$f = friendStatus($friendid, $myuserid);
displayrelationoptions($f, $friendid);
echo "</td></tr>";
}
echo "</table>";
} else {
echo "<h1>No Results</h1>";
}
break;
}
//Print off the Universal Footer of the page
include "footer.php";
<?php
include "authen.php";
include "config.php";
include "friendingfunctions.php";
header('content-type: text/xml');
$userid = intval($_GET['id']);
$myuserid = $_SESSION['userid'];
//If not own profile, let's look into friend status
$friendsquery = "SELECT * FROM relations RIGHT JOIN userinfo ON\n (userinfo.`userid` = relations.`userid1`\n OR\n userinfo.`userid` = relations.`userid2`)\n AND\n userinfo.`userid` != '{$userid}'\n AND \n \trelations.`relation` = '2'\n WHERE\n relations.`userid1` = '{$userid}'\n OR\n relations.`userid2` = '{$userid}';";
$friendsresult = mysql_query($friendsquery) or die("Unable to query DB!");
$xml = new SimpleXMLElement('<xml/>');
while ($row = mysql_fetch_assoc($friendsresult)) {
$friendsstatusquery = "SELECT userid1,userid2 FROM relations where (`userid1` = '{$myuserid}' AND relation = '2') OR (`userid2` = '{$myuserid}' AND relation = '2');";
$friendsstatus = mysql_query($friendsquery) or die("Unable to query DB!");
$friend = $xml->addChild('friend');
$userid = $row['userid'];
$friend->addChild('userid', "{$userid}");
$fname = $row['fname'];
$friend->addChild('fname', "{$fname}");
$lname = $row['lname'];
$friend->addChild('lname', "{$lname}");
$gender = $row['gender'];
$friend->addChild('gender', "{$gender}");
$bdate = $row['bdate'];
$friend->addChild('bdate', "{$bdate}");
$friendstatus = friendStatus($userid, $myuserid);
$friend->addChild('friendsstatus', "{$friendstatus}");
}
print $xml->asXML();
