I'm learning basic social networking off the Webintersect demo, in which a user's friend ids are stored in a text column in the format 3, 6, 99, 44 etc, so this is how I've set things up.
To add a friend, the whole array gets loaded into php and the id is added, then the new array string is saved back in mysql. However, I now see that it would be a problem if someone gets added when another transaction is in process.
What is a better way to store friend ids? A simple table with two columns - `your_id` and `friend_id`, so there's a new row for each of your friends?
Thanks for your help.