Member Avatar for deepucando

Hi

I want to create a database that can store the friends contact list as like social networking what is the best way to design the database structure and easy to retrieve the contacts of friends using mysql.

i need solution for this, HELP ME

regards
~Deepu~

  • 2 Contributors
  • 1 Reply
  • 91 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by metalix
Member Avatar for metalix

well you will need several tables:
member
id(AI, primary), username(unique), birthdate, date_joined, first_name, last_name, email, authentication, authorised, access

Explained
username - what it will show to others
authentication/authorised - this determines that the user has been verified to join/isn't a bot.
access - usually guest/user/moderator whatever levels you want to control thier access.

blogg
id(AI, primary) category, title(unique), data(blob), date, username


you might want to include other stuff but most of it will be handled with files and php scripts. hope this helps :)

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.