Hi all,
(Thought this was posted earlier, but does not appear, apologies if duplicated)
I have a table of essentially 3 drop down menus. Each of the drop down menus refers to different tables. The Link is the ID in each of the drop down boxes. The view would naturally be the text not the ID.
I need to access each of these tables (based on a primary key). Each of the IDs in each of the other 3 tables refers to text content.
What is the most efficient way of retrieving the text from each of the three tables in order I can populate the relevant variables.
I am assuming the Left join will allow me combine data from more than one table into a single result set, but unsure in practicality how this exactly works from a PHPR point of view.
Any pointers always appreciated.
Thanks
Adrian