Modify this script to include the forum and replies

[aceofspades]

Hey guys!

I am using a premade latest forum posts script, but i would really appreciate it if someone could tell me how to expand it to say not only which is the forum that the post was made in, but also the number of replies.

Here is my script as it stands:

<?php
$db_host = "localhost"; // Change this if your MySQL database host is different.
$db_name = "xxx"; // Change this to the name of your database.
$db_user = "xxxxxxx"; // Change this to your database username.
$db_pw = "xxxxxxxx"; // Change this to your database password.
$db_prefix = ""; //Change this to the prefix of the forum database.

$forum_url = "xxxx"; // Change this to reflect to your forum's URL.
$limit = "7"; // Number of posts displayed.
$txtlimit = "18"; // This is the character limit.

// Connecting to your database
mysql_connect($db_host, $db_user, $db_pw) 
OR die ("Cannot connect to your database"); 
mysql_select_db($db_name) OR die("Cannot connect to your database"); 

if ($limit) {
	$limited = "LIMIT $limit";
}

$thread_sql = mysql_query("select threadid,title,lastpost,firstpostid from $db_prefix thread where visible=1 $wheresql and open=1 $forumid order by lastpost desc $limited");

while($thread_get = mysql_fetch_array($thread_sql))
	{
		$lastpost = $thread_get['lastpost'];
		$tid = $thread_get['threadid'];
		$psql = mysql_query("SELECT postid from $db_prefix post where threadid=$tid order by postid desc");
		$getp = mysql_fetch_array($psql);
		$pid = $getp['postid'];
		$title = $thread_get['title'];
		$title = substr($title,0,$txtlimit);
		
			echo "<li class=\"item\"><a href=\"$forum_url/showthread.php?p=$pid#post$pid\"><span>$title</span></a></li>";
	}
?>
</ul>

The final result i would like is this:

Forum | Thread name | 9 Replies

Any help would be much appreciated!

[MoT3rror]

The column replycount in the table thread.

I hope you know your link is going to the post not the thread. Change it to

PHP Code:

<a href=\"$forum_url/showthread.php?p=$tid#post$pid\"><span>$title</span></a> 


[aceofspades]

Yeah sorry i meant recent posts not recent threads. I dont know what you mean by

The column replycount in the table thread.

.

I dont have any database or php knowledge. Im hoping to pull which forum the last post was in, and also how many replies there are in the thread the post was in. Is anyone able to help me out with this?

[MoT3rror]

I suggest you try this mod.
https://vborg.vbsupport.ru/showthread.php?t=147344