ccrevcypsys Posted October 15, 2007 Share Posted October 15, 2007 To set up a database table for friend adding. Like i want to be able to let the visitors of my site add friends. But i dont know how to set up the database. What is the best reference or columns i should have? Quote Link to comment Share on other sites More sharing options...
hvle Posted October 15, 2007 Share Posted October 15, 2007 what do you mean by "friends"? What exactly will "friends" be included? Quote Link to comment Share on other sites More sharing options...
ccrevcypsys Posted October 15, 2007 Author Share Posted October 15, 2007 well by friends i mean like on myspace(ughh) where you can add other people as your friends by clicking the add friend button then it would send the other person a request and they would either approve or deny so if they approve it will add them to the friends list. Quote Link to comment Share on other sites More sharing options...
hamza Posted October 15, 2007 Share Posted October 15, 2007 Man just simply make new database for the friends and simple execute the insert query and add your friends. AND about accepting and deny your friends. Just bring the details of your friend and put into the mail and send them for adding friend and denying friends thats it Quote Link to comment Share on other sites More sharing options...
MmmVomit Posted October 15, 2007 Share Posted October 15, 2007 I'm assuming you have a user table that looks something like this. User ------------- ID Username etc. You want to add a table that looks like this Friends ---------------- ID UserID => User.ID FriendID => User.ID Quote Link to comment Share on other sites More sharing options...
Barand Posted October 15, 2007 Share Posted October 15, 2007 You might want to add a datetime field and a status field (accepted/not accepted) to "friends" table. Periodically clear old, non-accepted records. Quote Link to comment Share on other sites More sharing options...
simcoweb Posted October 15, 2007 Share Posted October 15, 2007 I would assume you already have people registering as a member on your site? If not, there's no way they'd know who is who. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.