How to show newest thread in subforum

[frying_pan_cat]

I'm wondering what the easiest way to get a page to display the newest thread in a subforum. I'm wanting to know as I want to make an app where one of the buttons will go to the newest thread in a subforum to save having to navigate to it on a mobile device which usually takes ages over a mobile connection. Can anyone tell me how to achieve this?

 

[frying_pan_cat]

Thanks for the reply, it is a forum on a site I administer which runs on wordpress if this makes a difference. I have no idea about running an SQL query to find the right thread, I have only done a very little SQL ages ago and can't really remember any of it so if I could get any help with it or could be pointed in the right direction I'd be very grateful

 

[frying_pan_cat]

Thanks, that kind of makes sense but I'll have a look at the link and my site in the morning as I don't think my head's in the right mode to find it this evening. Thanks for your help