i have 2 tables:
1) father table.. (posts table)
2)child table.. (comments table)
now i ordered the results by (id of father) desc.....now what i want is if comment on some post,,,this post is being the first in the order!..
any help please ?
what query to use?
help in "order by" mysql
Moderator: General Moderators
- social_experiment
- DevNet Master
- Posts: 2793
- Joined: Sun Feb 15, 2009 11:08 am
- Location: .za
Re: help in "order by" mysql
Can you please rephrase this? Do you want the comments to appear in chronological order, i.e first comment last, last comment first?mekha wrote:now i ordered the results by (id of father) desc.....now what i want is if comment on some post,,,this post is being the first in the order!..
“Don’t worry if it doesn’t work right. If everything did, you’d be out of a job.” - Mosher’s Law of Software Engineering
Re: help in "order by" mysql
Behaviour similar to a forum? Topics are listed by order of most recent comment, then by order of post date?