<div>
hi<br />
<br />
you may be better off having a string of the friends ID's (im presuming each 'user' has a uniqu ID)<br />
you could not require a new table that way as you could add the column 'friends' to your users table<br />
<br />
if you had say 5 users:<br />
<br />
User1<br />
User2<br />
User3<br />
User4<br />
User5<br />
<br />
and User1 added the other 4 as friends you would store the following:<br />
User2,User3,User4,User5<br />
<br />
you would then be able to iterate through that list to find all the friends of a user<br />
<br />
hope this helps<br />

</div>


<div>
Sorry, i'm fairly new to Mysql. <br />
<br />
If I have a column for Friends in the table, would it not overwrite the content when a new friend is added?<br />
<br />
How can I set this column to take multiple entries, and then how can I then display this?<br />
<br />
Man thanks for your quick response. 
</div>


<div>
<div class="content wysiwyg-content">
Hi there, <br />
I am creating a site for musicians/bands at the moment, sort of like a social networking site, but also not at the same time...<br />
<br />
I want members of the site to be able to add bands/musicians as 'Friends' (in a facebook kind of way, except known as fans) and was wondering how is best to do this. <br />
<br />
I was thinking of adding a new table in my database with just two fields, 'Friend 1' and 'Friend 2'. When someone adds a friend, their name will go into 'Friend 1' and their new friend into 'Friend 2'. So then to display someones friends on their profile, filter by 'Friend 1' and display all 'Friend 2's.<br />
<br />
Only problem is, the table will get pretty big pretty quickly, won't it?
</div>
</div>


Hi there, 
I am creating a site for musicians/bands at the moment, sort of like a social networking site, but also not at the same time...

I want members of the site to be able to add bands/musicians as 'Friends' (in a facebook kind of way, except known as fans) and was wondering how is best to do this. 

I was thinking of adding a new table in my database with just two fields, 'Friend 1' and 'Friend 2'. When someone adds a friend, their name will go into 'Friend 1' and their new friend into 'Friend 2'. So then to display someones friends on their profile, filter by 'Friend 1' and display all 'Friend 2's.

Only problem is, the table will get pretty big pretty quickly, won't it?

'Friends List' in MySql/Dreamweaver PHP

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Adobe Dreamweaver is a web development tool featuring both WYSIWYG and code editors that allow the user to quickly and easily build websites in a wide variety of languages, including ASP, ASP.NET, ColdFusion and PHP. It also offers support for CSS and JavaScript.