Member Avatar for LRNPHP

Hi There,

MySQL is not my strong point so any guidance or advice will be greatly appreciated. I want to know what's the best way of linking multiple MySQL tables together. I have +-10 tables that will interact with each other.

Example Tables : users, logins, communication, sightings etc.

When the user uploads a picture it should store data in multiple tables for the specific upload and when he want's to view his upload it should use all the tables to populate all the info etc.

Kind Regards

  • 2 Contributors
  • 2 Replies
  • 172 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by LRNPHP
Member Avatar for urtrivedi

whatever is the database, selection of primary keys and foreign keys play important role in database design.

Member Avatar for LRNPHP

Hi Urtrivedi,

Thanks for the quick reply, so the best way of linking multiple tables is with the use of PRIMARY KEY's and FOREIGN KEY's

Kind Regards

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.