根据表以不同方式显示mysql join / union结果

Question

I need to generate a list of activity from multiple tables in order of the date they were entered into the tables, but when I spit them out (with php), I want each result to look specific to a design that I have for each table.

I.e... I have the tables: listings, photos, comments

• The results from listings should be designed a certain way, the results from photos should be designed a different way, the results from comments should be designed a third way.
• I would like to mesh the results from all three tables into one date-ordered list.

I can pull the results with a MySQL join, but I don't know how to alter the results according to the table.

Does this make a sense?

Answer 1

The process is this:

• Query Database, get results back ordered by date
• Iterate over results creating table, based on date/variable you will assign a CSS class to the current row you are creating. (use an if/switch/function etc. to figure out what class should be assigned)
• After iteration is done complete the table / etc. and display.