joining two queries into one

[kenny873]

i have a forum and want to get the data of "Who is the last person updating the message with messageID = $q_id."

I am very new to sql, so I choose to use two mysql query to get the result, however, since I am implementing this in a php called function, how can I join the following two queries into one...

1) select max(q_id) from game_forum where parent_q_id = $q_id OR q_id = $q_id ;

--> parent_q_id = $q_id means that it is a child thread.
--> it then pass the result($LastUpdQID) to the following query.

2) select userID from game_forum where q_id = $LastUpdQID;

how can I joing these two queries into one and get the last updated userID?

[abmohan75]

Try with the following query. I hope it may work
properly.

Select uid,q_id from game_forum where
parent_q_id = $q_id and q_id = (Select max(q_id) from game_forum where parent_q_id = $q_id)