Jump to content

help showing friends added


zhshero

Recommended Posts

I'm trying to make it so i can show the friends i added, or users that added a friend

 

<table border=2 width="250" height="125"><tr>
<?php
$userfinal = get_username($_SESSION['user_id']);
$Members = mysql_query("SELECT * FROM friends WHERE username='$userfinal' AND friendname");
$numRowsMembers = mysql_num_rows($Members);

for($count = 1; $count <= $numRowsMembers; $count++)
{
    $name = mysql_fetch_array($Members);


?>
<td width="150" height="125">
<a href="view_profile.php?username=<? echo $name['friendname']?>"><img src="<? echo $name['main_P']?>" width="100" height="100"/>
<? echo $name['friendname']?></a>

<?
if (isset($name['date']) && (time() - $name['date'] > 300)) {

echo 'offline =[';
} else {

echo "<font color=green>[Online Now!]</font>";
}
$name['date'] = time(); // update last activity time stamp
?>

</td>




<? } ?>
</tr></table>

 

 

database

 

id 	friendname 	username
12 	kristybellexo 	zhshero
13 	demo 	zhshero
14 	zhshero 	zhshero

Link to comment
https://forums.phpfreaks.com/topic/219252-help-showing-friends-added/
Share on other sites

ok nvm i got what i needed

<?


$Members = mysql_query("SELECT * FROM friends WHERE username='$Username'") or die(mysql_error());

$numRowsMembers = mysql_num_rows($Members);
?>

<?php
for($count = 1; $count <= $numRowsMembers; $count++)
{
    $name = mysql_fetch_array($Members);


?>


<? echo $name['friendname']?></a>

<? } ?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.