hey people
i am designing a website in php/mysql . well it is a social network. simple one. but i didnt know how to allow people to add friends . so i found the easiest way for me is to create a separate mysql table for each member containing all his/her friends.
but i am not sure if this will be fine.
couz lets say if my site got about 1000 new visiter per day. this will be 1000 new mysql table . is it realy going to be fine ??
if not. please tell me another way that can be better.
Awah Mohamed
-5
Junior Poster
Recommended Answers
Jump to PostWell data model isn’t something you decide through programming it should be set on a analysis base (if you are in a large scale project between demand department and analysis, programmer and feedback and if you are your own when you design the needs of your application before even write …
Jump to Postfor ease of sql queries and such I would make a table called friends with only 3 fields: id, friend1, friend2 (although you could name it more appropriately)
anyways for each and every user/friend store their id in friend1 and their friend's id in friend2. this means that each …
All 6 Replies
jkon
535
Posting Whiz in Training
Featured Poster
Awah Mohamed
-5
Junior Poster
HG&C
0
Newbie Poster
Awah Mohamed
-5
Junior Poster
HG&C
0
Newbie Poster
mschroeder
251
Bestower of Knowledge
Team Colleague
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.