MySQL Forums
Forum List  »  Newbie

Help in query
Posted by: Bharati Raul
Date: May 11, 2005 11:25PM

I have one table called blog_header with following fields:
parent, email, title, child, posted, postid, message, totalreply, visible, replyid

I want to disply the latest posting first but at a same time the related sub posting also move up with the related posting. for e.g. If suppose I am having following posting:
-> Posting 2
-> 1 Reply to Posting 1
-> 2 Reply to Posting 1 (latest posting)
-> 1 Reply to 2 Reply to Posting 1
-> Posting 1
-> Posting 3

This is the posting structure should be. How can I fire the query.

I am trying to post a query like this :
select * from blog_header group by title order by postid desc.

Here, I kept the same title for main as well as sub posting therefore above query displays only main posting not the subposting in desc order.

Options: ReplyQuote


Subject
Written By
Posted
Help in query
May 11, 2005 11:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.