Page 1 of 1

help in "order by" mysql

Posted: Wed Sep 19, 2012 5:59 am
by mekha
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?

Re: help in "order by" mysql

Posted: Wed Sep 19, 2012 7:13 am
by social_experiment
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!..
Can you please rephrase this? Do you want the comments to appear in chronological order, i.e first comment last, last comment first?

Re: help in "order by" mysql

Posted: Wed Sep 19, 2012 9:11 am
by Celauran
Behaviour similar to a forum? Topics are listed by order of most recent comment, then by order of post date?