Hey guys, I was hoping someone could help me out here again.
I've seen people pulling entries from multiple MySQL tables by using the JOIN clause, but I can't seem to get it to work with what I am trying to do.
I have 3 tables which I wish to display ALL the info from on one PHP page.
I have 3 separate PHP files which each display their corresponding MySQL tables, but I want to have ONE page which displays all of them at once by order of "date" (kind of like a "latest updates" page of some sort).
What is the easiest way I can go about doing this?
My tables are "sports", "news", and "recipes", and they all have the fields "id", "title", "date", "content".