help in "order by" mysql
Posted: Wed Sep 19, 2012 5:59 am
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?
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?