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.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.