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.