help in "order by" mysql

[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?

[Ingolme]

Hmm... You would need to join the tables. I think something like this might work:

SELECT posts.field1, posts.field2 FROM posts, comment WHERE comment.parent = post.id ORDER BY comment.date

[mekha]

Sorry man ... not 2 tables...comments and posts in the same table...the post:parent_id = 0 / the comment:parent_id = $postid .... any another suggestions ?

[mekha]

mmm ok... i solved it....i created another date field in the table...and when adding a comment...update the date of post field to the same of the comment and order by this field ...thank you man