PHP - Who's Friends With Who Or Whom?

I have just a general question about a friends system here with regards to the database design.......

lets say you have a website where users can rent books.  The database design would be


MEMBER                                    BOOK                                                              LINk
memberid                                  isbn                                                                 memberid
name                                         name                                                              isbn
                                               
Or something to that extent

Now with a friends system like facebook has that "LINK" table would be absolutley huge and I cant see it being good design practise.  I mean how do you suppose facebook does this. Do they have ......

FRIENDS
myID
friendID


and just millions upon millions of repeated data?

 The only way I can see would be in the member table have a field called friends and then the ID's of each friend like so


Friends
001, 002, 003, 004, 005, 006, 007,

Now is my logic correct here or am I thinking of this totally the wrong way?  Would the other way be a better option or would it take the system too long to get to the 1000,000 th record in the database?

I believe the first option would be correct but I cant see how the server would handle the request if say you had 1000,000 users.  It just seems to me that you would create too many records. 

In my website people can sign up to mulitple events but if every user had 100 events the link table would just be massive!!!!!!!!!!!!!!!!!!!!!!

Im just after peoples input really on the situation.

Thank you

I have a database with all users.. Within that database all users have an id. How would I make it so users can "friend" other users? Would I need to make a new table for that?

Im sorry for the dumb question.. I havent dealt with php or mysql in about two years because I was busy getting engaged and all.. But now that I have time again I think im gonna take up one of my old projects. Granted I probably could have answered this question myself back then but now im finding some trouble taking up programming again. :\

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

Hi all

 

This part is integral to my site and im panicking as i cant seem to find an answer...

 

When someone clicks a link on my page with the below code it only does it as services... how can i create a paypal link to charge as friends and family PLEASE PLEASE PLEASE HELP

<form id="payid" name="_xclick" action="https://www.paypal.com/cgi-bin/webscr" method="post"> 
<input type="hidden" name="cmd" value="_xclick"> 
<input type="hidden" name="business" value="<?php echo $row1['EMAIL']; ?>"> 
<input type="hidden" name="currency_code" value="GBP">
<input type="hidden" name="item_name" value="BALL"> 
<input type="hidden" name="amount" value="<?php echo preg_replace( '/[^0-9,"."]/', '',  $row['PRICE'] ); ?>">
<!--<input type="hidden" name="return" value="http://www.theeasypc.co.uk/lottery/heandal.php">-->
<input type="hidden" name="return" value="http://www.theeasypc.co.uk/lottery/heandal.php?success=1">
    <input type="hidden" name="cancel_return" value="http://www.theeasypc.co.uk/lottery/heandal.php?error=1">

    <!-- Where to send the PayPal IPN to. -->
    <input type="hidden" name="notify_url" value="http://www.theeasypc.co.uk/lottery/heandal.php" />
<input type="image" src="http://www.paypal.com/en_US/i/btn/btn_buynow_LG.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
</form>

I can see the  its set to business in one flag but ive tried to change thie to f&f, personal, friends, family, nothing works also tried "_donations"

 

 

Here is the error code I am receiving;   Parse error: syntax error, unexpected $end (line 41)   The error message has consistently identified the statement in the else clause.  Thanks for any help.

<?php session_start(); ?>

   <!DOCTYPE html PUBLIC "-//W3C//DD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

       <head>
       
	 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"  />
         <title>Blah</title>
         <link rel="stylesheet" type="text/css" href="defaultcss.css" />

       </head>

	  <body>
	
	      <div id ="wrapper">
	
	      <h2>Blah Forum Demo</h2>
	
	      <p>Creating basic login functionality</p>
	
	<?php
	
	if (!isset($_SESSION['uid'])) 
	{
		echo "<form action = 'login_parse.php' method ='post'>
		Username: <input type ='text' name='username' /> &nbsp;
		Password: <input type ='password' name='password' /> &nbsp;
		Submit: <input type ='submit' name='submit' value='Log In' />
		";
	}
	else
	{
		echo "<p>You are logged in as ".$_SESSION['username']." &bull; <a href='logout_parse.php'>Logout</a>;
	}
	?>
	
	</div>
	
	</body>

</html>		

Hi Guys

 http://www.phpfreaks.com/forums/Smileys/nrg_alpha/cool.gif
Cool

I have social networking application. I am trying to query a database to get the ids of all the users friends.  With the ids of all the users friends I am then trying to  query a second database with  the status feed  that contains all users status data.

 

I would like to echo the users friends status data only from the second database

 

code is below hope you can help.

 

Thank you.

 

<?Php
session_start();
?>
<?Php
//connect.
include("connect.php");
//Time ago coverting code.
include_once("classes/develop_php_library.php"); // Include the class library

 

$id=$_SESSION['id'];

 

/*find-out users friends*/
$findperson=mysql_query("SELECT * FROM friends WHERE sessid='$id'");

 

$timeAgoObject = new convertToAgo; // Create an object for the time conversion functions

 

$findfriend=mysql_num_rows($findperson);

 

//Count if the person has any friends. If they have friends get the ids of all their friends
if($findfriend>0)
{
while($rati=mysql_fetch_assoc($findperson))
{
    $fried=$rati['friendid'];

 

    //query the status table to give the users friends status.

 

    $mediafeeds=mysql_query("SELECT * FROM status WHERE userid='$fried' LIMIT 0,8");

 

    $media_num=mysql_num_rows($mediafeeds);
}

 

//count to see if their any status updates from users friends.

 

if($media_num>0)
{

 

//display all the users friends status data.
$datamedia="<TABLE BORDER='0' CELLPADDING=8 bgcolor='#FFFFFF' align='center' width='350px' height='30px'>";

 

while($mini=mysql_fetch_assoc($mediafeeds))
{
$user_id=$mini['userid'];
$viewer_nme=$mini['username'];
$viewer_picture=$mini['viewerpics'];
$media_pic=$mini['contentpic'];
$desc_ption=$mini['description'];
$date_time=$mini['date'];

 

$convertedTime = ($timeAgoObject -> convert_datetime($datetime)); // Convert Date Time
$datetime = ($timeAgoObject -> makeAgo($convertedTime)); // Then convert to ago time

..

//This is just a table with the data of all the users friends data.


$datamedia.="<tr><td valign='top' cellpadding='5' width='10%' bgcolor='#FFFFFF' align='center' >$viewer_nme<br/><a href='friendsprofile.php?uid=$uidd&&viewer=$id'><img src='".$mediapic."' width='80' height='80' align=left></td>
      <td valign='top' align='left' cellpadding='5' width='60%' bgcolor='#D3D3D3' cellpadding='0'>$introduction<br/>$titlenamed$titled<br/>$descd$desc_ ption<br/><br/>$datetime</td></tr>";

 


    }
$datamedia.="</TABLE>";
echo $datamedia;
}
else
{
echo "<font color='#333333' size='2' face='sans-serif' align=left><div align='center'> Your friends have not current activities.</div></font>";
}
}

else

{

 

 

}

I am trying to make a filter to show posts from mutual friends between you and the persons profile you're on, I have somewhat of an idea on how to write the mysql query (it needs to be just one query, not two(which would be the easy way of doing it)).

the "friends" table has:
"friend_1" and "friend_2"

and the "posts" table:
"to_id" and "from_id"

The PHP variables would be:
"$session" and "$id"
id would be the users Id of the profile you're on.

Thanks, any help would be appreciated.

I'm working on  a Social Network from scratch. I'm stuck on how to store friend relationships between users?
On one topic here, I found an idea.
Have a table with 3 columns; id,user_1,user_2
each relationship would have a new row in the database.
Would this be the best way to do this? I can imagine the table would get quite big.
If each user has 100 friends and there's 10000 users that's 1000000 rows. etc