How can I query all tables and sort them by the published time? For example, I made a forum where posts for each topic were placed in a separate table. I posted posts for the hardware, software, and programming sections respectively. now I am in my personal center, how can I display all my posts and sort them by release time? Ask for advice! How can I query all tables and sort them by the published time?
For example, I made a forum where posts for each topic were placed in a separate table. I posted posts for the hardware, software, and programming sections respectively,
Now, in the personal center, I want to display all my posts and sort them by release time. what should I do? Ask for advice!
Share:
------ Solution --------------------
Union data table.
------ Solution --------------------
Design the topic table and post table, and associate the Post table with the topic table. retrieve all subclass and parent classes of the topic table and the associated post content, it mainly depends on how your table is designed ,,,
------ Solution --------------------
Create a user-Post Relationship Table, record all the items to be queried, and then check the relationship table.