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.