Friends list

[Toxikr3]

Hi guys, I am in need of a simple friends list code. I don't know how to start it, but I have gotten an idea, maybe anyone of you can help?

I have setup a database with login and password, I want to also add a Friends column. I will setup a "Profile page" soon, and from there I want a button to add that person. It simply puts the name of the person in the Friends column and adds a comma.

When reading the column it should go to a next line as soon as it sees a comma, thus separating the friends.

Any help? Or if you have a simple friends script that works and you would be generous enough to let me use it, that would be great.

-Toxikr3

[paradox814]

You would need a SELECT statement in SQL to do this, the same way you inserted all of your friends to the database just ...

SELECT id,firstName,lastName FROM Profiles WHERE isVisible='1'

of course you will need to change the names based on your table structure.

[xide007]

I just accomplished this :) but with the guy above has the right idea it's all about mysql queries and narrow them down which takes time to do but worth it at the end!

I don't think anyone will share the source :icon_lol: but then again you might just find one person who is lovely that wants to give you a piece of cake. Good luck with it, sorry this reply hasn't been useful but hope it sheds some light on the idea :) Got any questions I'll be gladly to help you.

[mrcniceguy]

you can Also do like this
1.create a separate table call it friends with fields ,friend and username.
2.when someone is logged in and wants to add A friend he inserts
two rows.

mysql_query(INSERT INTO friends (friend,username) VALUES('$friend','$username'));

mysql_query(INSERT INTO friends (friend,username) VALUES('$username','$friend'));

when displaying friends list
just like this

SELECT *FROM friends WHERE username="$username";

Dont forget to include the friendsRequest table to insure that u just add someone u wish to be ur friend.

[diafol]

WRT your original idea, I'd advise against having a comma separated list in your friends column. This would make it difficult to search friends. You need a dedicated friends table:

friend_id (autonumber/int)
user_id (int : foreign key on user_id in user table)
friend_id (int : foreign key on user_id in user table)
status (tinyint : e.g. 0 = not accepted yet, 1= accepted, 2 = declined)

This should work with an invitation to be a friend system. Or if you just want to add (like Daniweb's system), no need for status column.

[Toxikr3]

Thank you for the replys guys, it has given me an idea to work around with. I'll try it out and see if it works.

Though I am wondering how to send the confirm message to the certain person.

-Toxikr3