Having trouble rewriting this SQL query

[zeroality]

I duplicated the error and left it online for you to check out. I really appreciate the help!

http://www.pokerealm.net/news/

I also took out the redirect script in the iFrame incase you wanted to view that as well.

http://www.pokerealm.net/announceframe.php

Here are .txts of the iframe source and the php source. PHP code probably isn't optimized, I can fix that later.

http://www.pokerealm.net/zero/login_inc2.txt
http://www.pokerealm.net/zero/announceframe.txt

Edit: I just noticed (by looking at the iframe by itself - hadn't tried that) that the SQL error is from the SECOND query I am running down there. However, I will just let you take a look at the whole shebang so hopefully I can get better advice on how to write this hack as a whole. (If you end up writing it, feel free to release it as a MOD or something - just credit tantawi for the original stuff.)

I want to display the title/text/replies/views of the latest 5 threads from my news forum.

Edit2: Nevermind. It's ugly but I just set up a separate query for pulling each thread so 5 news articles = 10 queries. I can live with that I suppose.

http://www.pokerealm.net is what I ended up with. Man, someone should really rewrite this 'correctly' and release it as a MOD - as well as that vbulletin 'sidebar'. Those would be MotM easy!