[FFMG]

Hi,

The code below displays the last 5 posts, but I am not happy with making that many queries.
Would there be a better way of doing it with just one querry?

	global $db;

	$threads = $db->query_read("
		SELECT threadid,title,lastpost,lastposter
		FROM " . TABLE_PREFIX . "thread
		WHERE visible=1 AND open=1 ORDER BY lastpost DESC LIMIT $count
	");


	$res = "";
	if ($num_thread = $db->num_rows($threads))
	{
		$data = false;
		while ($thread_get = $db->fetch_array($threads))
		{
			$lastpost = $thread_get['lastpost'];
			$poster = $thread_get['lastposter'];
			$tid = $thread_get['threadid'];

			$post = $db->query_read(
				"SELECT postid FROM " . TABLE_PREFIX . "post WHERE threadid=$tid ORDER BY postid DESC LIMIT 1"
			);

			if( $num_post = $db->num_rows($threads))
			{
				while( $getp = $db->fetch_array($post) )
				{
					$pid = $getp['postid'];
					$title = $thread_get['title'];
					$title = substr($title,0,100);

					$ref = "<a style=\"font-size:xx-small;\" href=\"showthread.php?p=$pid#post$pid\">$title</a>";

					$data .="
							<tr>
								<td  align=\"left\" width=\"100%\">
								$ref
								</td>
							</tr>";
				}
				$db->free_result($post);
			}
		}

		if( $data !== false )
		{
			$res = "
			<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
			<tr>
				<td  align=\"center\" width=\"100%\" class=\"tcat\" style=\"font-size:x-small;\">Recent Posts<br />
				<a style=\"font-size:xx-small;\" href=\"faq.php?faq=new_faq_item#faq_new_faq_item1\"><u>HTTPpoint is an Ad revenue sharing forum</u></a>
				</td>
			<tr>

			".$data."

			<tr>
				<td  align=\"center\" width=\"100%\" class=\"tcat\" style=\"font-size:x-small;\">
				<a style=\"font-size:xx-small;\" href=\"showthread.php?t=3526\">Discuss this SEO tool</a>
				</td>
			<tr>

			</table>";
		}
	}
	$db->free_result($threads);

	return $res;

Thanks

FFMG