I have a database with the table name "Controllers" and the primary ID and other fields. Each time their is an event (alarm) the database creates a new table the name being based on the primary ID from one of the rows from the table "Controllers" to which the event relates to.
Thus for example a Table "Alarm212" is created (the 212 is one of the primary ID's in the Table "Controllers")
Is it possible and what would such a php statement be so that when viewing the data in the Table "Controllers" on a Web Page the php function is run for a particular row when a button is clicked, which then runs the php based on the "Controllers" primary ID in that particular row so it finds and the appropriate Table and then displays the info from this Table "Alarms212" , etc...
New tables, Alarms 213, Alarms 214, are continually being added to the database.
Any guidence will be appreciated.