Welcome Guest, Not a member yet? Register   Sign In
friend system?
#2

[eluser]xwero[/eluser]
two tables is all you need to start

persons : id, name, ...
friends : person_id, friend_of

You could put the friend_of field in the persons table, as long text field filled with a comma separate list, but then you would have to use sql statements like
Code:
select name from persons where friend_of like '%?%'
which aren't that fast as
Code:
select person_id from friends where friend_of=?

I hope this gets you started.


Messages In This Thread
friend system? - by El Forum - 10-18-2007, 10:12 PM
friend system? - by El Forum - 10-18-2007, 11:59 PM
friend system? - by El Forum - 10-19-2007, 12:16 AM
friend system? - by El Forum - 10-19-2007, 12:40 AM
friend system? - by El Forum - 10-19-2007, 12:49 AM
friend system? - by El Forum - 10-19-2007, 12:54 AM
friend system? - by El Forum - 10-19-2007, 01:00 AM
friend system? - by El Forum - 10-19-2007, 03:25 AM
friend system? - by El Forum - 10-19-2007, 04:36 AM
friend system? - by El Forum - 10-19-2007, 05:58 AM
friend system? - by El Forum - 10-19-2007, 06:05 AM
friend system? - by El Forum - 10-19-2007, 06:08 AM
friend system? - by El Forum - 10-19-2007, 06:17 AM
friend system? - by El Forum - 10-19-2007, 10:37 AM
friend system? - by El Forum - 10-19-2007, 12:34 PM
friend system? - by El Forum - 10-19-2007, 12:47 PM
friend system? - by El Forum - 05-13-2010, 10:13 AM



Theme © iAndrew 2016 - Forum software by © MyBB