Implement friends

[Jettford]

[SimonNitzsche]

Handy dandy SQL for getting friends list assuming _table ------------------- objectA | objectB

SELECT objectA AS v FROM _table WHERE objectB = ? UNION SELECT objectB AS v FROM _table WHERE objectA = ?;

[Jettford]

What does UNION do?

[Jettford]

Handy dandy SQL for getting friends list assuming _table

objectA | objectB

SELECT objectA AS v FROM _table WHERE objectB = ? UNION SELECT objectB AS v FROM _table WHERE objectA = ?;

The table would also contain a bool for best friend

[SimonNitzsche]

It merges both selects. This will then give you a list of the other object where objectA = ? or objectB = ?