Need help picking out a thread using SELECT (mySQL)

[zeroality]

I'm trying to rewrite a hack to fit my needs and what the original hack does is take the first thread from a forum that you specify and display it on FORUMHOME.

I've successfully modified it to show views and replies but I can't get it to pick out the second thread in the forum and display it as well.

Here's the plugin code:

// ### LATEST NEWS BY TANTAWI ############################################
		$latesta = $db->query_first('SELECT title,threadid,views,replycount FROM ' . TABLE_PREFIX . 'thread WHERE 1 AND forumid = 28 ORDER BY dateline DESC  LIMIT 1');
		$lns_show = "<a href=\"showthread.php?"  . $vbulletin->session->vars['sessionurl'] . "t=$latesta[threadid]\">$latesta[title]</a>";
		$lns2_show = "<b>Replies:</b> $latesta[replycount] <b>Views:</b> $latesta[views]";
		$latesta2 = $db->query_first('SELECT title,threadid,views,replycount FROM ' . TABLE_PREFIX . 'thread WHERE 2 AND forumid = 28 ORDER BY dateline DESC  LIMIT 1');
		$lnsb_show = "<a href=\"showthread.php?"  . $vbulletin->session->vars['sessionurl'] . "t=$latesta2[threadid]\">$latesta2[title]</a>";
		$lnsb2_show = "<b>Replies:</b> $latesta2[replycount] <b>Views:</b> $latesta2[views]";

I thought setting "WHERE" to 2 would do the trick since the first one is "1" but that just makes it display the first thread all over again. This is probably a simple question - I'm still learning and doing well, just stuck on this.

Thanks in advance.

Edit: Haha, I'm so stupid, I just noticed the variable name. That'll probably fix it. Let me go give it a try.

Edit2: Didn't work, updated code with what I'm trying to use now. It still displays the first thread, not the second.

Edit3: Nevermind, figured it out. I'll repost another topic when I'm all done and ask if there's a way to optimize my code.

[Code Monkey]

That is because you are using query_first() which only takes the first one it finds. Use query_read().