making a friends list
Posted 15 September 2006 - 04:19 AM
Posted 15 September 2006 - 08:43 AM
The first table will store the user's name, user id and other data (password, name, etc etc).
The second table will have two columns, "id1" and "id2". A row in that table means "id2 is a friend of id1".
The problem with using columns is that you don't know how many columns you need. Rows make life much easier
Posted 15 September 2006 - 12:41 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users