$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();