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!
Reply to discussion (solution)
Each table has a field that records the sender, user, who posted the post, which is the user name in this field.
Union data table.
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 ,,,
Create a user-Post Relationship Table, record all the items to be queried, and then check the relationship table.
I don't understand what linux_PHP _ says.
Use union. It seems that your table design is problematic.