Avatar of Sonny100

asked on 

'Friends List' in MySql/Dreamweaver PHP

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?
PHPMySQL ServerAdobe Dreamweaver

Avatar of undefined
Last Comment

8/22/2022 - Mon