[Originally posted by Reuven Boim]

Hi
i have a question about the query i will need to write to use a forum..
i want to show on the main page the main msg and all its childs (1 msg can get many many replys)

in the DATABASE there is a filed of the "father msg"
i would like to know how do i do the query? i need to do a special query to each msg to check if it has children or i can do it somehow with 1 query??
thanks,

  Reuven Boim