renwoshin Posted January 22, 2006 Share Posted January 22, 2006 hi, i'm trying to make a friend's list type thing for our users, but I'm not sure how I should represent it in a database. Here are the possibilities I thought of:1) make a table for every username and every row would be a friend2) make one table for all the usernames and add a column for each friend3) somehow make a table within a table (is this even possible?) with the inner table being the friends of the usernameWhat do you guys think would be the best representation for a "friend's list"? Link to comment https://forums.phpfreaks.com/topic/3239-trying-to-implement-a-friends-list-but-not-sure-of-how-to-represent-it/ Share on other sites More sharing options...
renwoshin Posted January 22, 2006 Author Share Posted January 22, 2006 specificially, would it be inefficient to add a table for each user? Like, if we had 3000 tables for one database, will that be bad? Link to comment https://forums.phpfreaks.com/topic/3239-trying-to-implement-a-friends-list-but-not-sure-of-how-to-represent-it/#findComment-11051 Share on other sites More sharing options...
renwoshin Posted January 24, 2006 Author Share Posted January 24, 2006 so no one knows the maximum number of tables in a database? Link to comment https://forums.phpfreaks.com/topic/3239-trying-to-implement-a-friends-list-but-not-sure-of-how-to-represent-it/#findComment-11065 Share on other sites More sharing options...
fenway Posted January 24, 2006 Share Posted January 24, 2006 Don't do it that way -- I've posted a response to your question on [a href=\"http://www.mysqlfreaks.com/forums/index.php?showtopic=8962&hl=\" target=\"_blank\"]this MySQLFreaks.com thread[/a]. Link to comment https://forums.phpfreaks.com/topic/3239-trying-to-implement-a-friends-list-but-not-sure-of-how-to-represent-it/#findComment-11082 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.