2006-10-22, 07:47 AM
How to edit this code (Last post to show on homepage)
This code it work but it show reply include (i don't want reply)
I want to show last post only How to edit
Thank for help me !!!!!!!!
This code it work but it show reply include (i don't want reply)
I want to show last post only How to edit
Thank for help me !!!!!!!!
Quote:<?php
$mysqlhost = "localhost";
$mysqlusername = "";
$mysqlpassword = "";
$mysqldbselect = "";
$prefix = "mybb_";
$fid = ;
$limit= ;
mysql_select_db($mysqldbselect, mysql_connect($mysqlhost,$mysqlusername,$mysqlpassword));
$query = mysql_query("SELECT t.tid,t.subject,t.uid,t.username,t.replies,t.views FROM ".$prefix."threads t LEFT JOIN ".$prefix."posts p ON (t.tid = p.tid) WHERE t.fid='".$fid."' AND t.visible='1' AND t.closed NOT LIKE 'moved|%'") or die(mysql_error());
while($news = mysql_fetch_array($query))
{
echo "<div style=\"padding:2 px\"><img src=right.gif border=0 alt='Topic $tid'><a href=\"showthread.php?tid=".$news['tid']."\" target=\"_blank\">".$news['subject']."</a> | reply : ".$news['replies']."| view: ".$news['views']." </div> ";
}
?>