Having trouble rewriting this SQL query

[zeroality]

Currently it only extracts data from the first thread in a specific forum. I want it to call the first 5 threads instead.

Current code:
$latesta = $db->query_first('SELECT title,threadid,views,replycount,postusername,datel ine FROM ' . TABLE_PREFIX . 'thread WHERE 1 AND forumid = 28 ORDER BY dateline DESC LIMIT 0 , 1');

Rewriting it to this:

$latesta = $db->query('SELECT title,threadid,views,replycount,postusername,datel ine FROM ' . TABLE_PREFIX . 'thread WHERE forumid = 28 ORDER BY dateline DESC LIMIT 0 , 5');

Returns a mySQL error so I'm stuck. Any help is appreciated, thanks.

[Adrian Schneider]

What's the MYSQL error?

[zeroality]

Database error in vBulletin 3.6.0:

Invalid SQL:

That's all it says, after displaying this:

Database Error Database error
The PokeRealm.net Forums database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.pokerealm.net home page, then try to open another page.
* Click the Back button to try another link.

The www.pokerealm.net forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

[Adrian Schneider]

View the HTML source so you can see the hidden error message.

[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!