Getting data from a phpBB database

[Zucarita9000]

Before you say anything, I already posted this on the phpBB forums, it's just that I need a quick answer

I have a phpBB board setup, with a dedicated forum for Polls. Only admins can post there (although anyone can vote).

I want to be able to display the latest poll title in my website's front page, so I need to get the data directly from the phpBB database, making sure it's the latest post (and not a reply from another admin nor an earlier poll).

I've come up with this query, feel free to complete it.

FYI, 10 is the forum_id where all the polls are.

 

[Gooberlx2]

I dunno what the database layout for phpBB is off hand, but you'd probably want to specify that you want the latest poll. Which would simply be the latest entry in that DB right? So something about the topic_title = count-1, or whatever....I haven't done DB queries in a long time.

You'll want to grab the URL of the topic as well for when you link it.