multiple tables read from mysql using json
Hello all, I have a task where I have to dynamically call in data from a mysql database to 4 seperate pages. Each page contains basically the same information but is relevent to a different college. The tables are collages, classes and feedback. Each page will take information from each of these databases tables. The tables are linked via the college_id key. I am using php and json to get the data. It is easy enough to use an array and use the index of the array to find the correct record of a table and append it to a div on a singular page. I have created an array that takes all the records of the table read so perth college record 1 is array, blairgowrie college is record 2, array and so forth.
What I want to know is there a way I can take the id received from this array and use it to place the correct data onto the page, perth college details on the perth college page and blairgowire details on the blairgowrie page, but to do this only using the one json function. Is it possible or will I have to make multiple json function to carry out for the seperate pages.:thumbsup: