Control panel that displays like Webassist Email block. - a lot of tables (23 tables) based on an ID
Can I call you later?
Trying to create a content manager page (for viewing quote requests) that displays like Webassist Email block. - that displays (joins?) a lot of tables (23 tables) based on an ID.
What I would like is:
Select * from TABLE1, TABLE2, TABLE3, TABLE4 etc, WHERE quote_id_person = $valuepassedfromurl
Then display all tables (rows wherever that id exists), as left and right (Column name and Value).
See below - (all 23 tables have the Quote ID but have different columns (some are same) so I would like it to display like the Details page that Webassist creates, plus one displaying underneath the other.(or similar to Email that is sent where all the $_POSTS are keys value pairs), so the Columns would be the $PKey since all the tables have differing columns, and the value would display on the right of it. I have some understanding of Mysql JOINS so I found one online but not doing exactly what I want.