Ive found a small script
Code:
<?php
// CONNECT TO DATABASE
$forum_database="db_name";
$forum_db = @mysql_connect("host","user","pass") or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor><br><br><br><center><font color=FFFFFF face=vernada size=6>Database Error</font></center></body></html>");
@mysql_select_db($forum_database,$forum_db) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor><br><br><br><center><font color=FFFFFF face=vernada size=6>Database Error</font></center></body></html>");
// GET THE LAST 13 POSTS
$mysql_query = "SELECT post.threadid, post.username, post.dateline, post.title, post.pagetext FROM post, thread WHERE post.threadid=thread.threadid and forumid=xyz GROUP BY thread.lastpost DESC LIMIT 13";
$res=mysql_query($mysql_query,$forum_db);
$num_rows = mysql_num_rows($res);
for($count=0;$count<$num_rows;$count++){
$username=mysql_result($res,$count,"username");
$dateline=mysql_result($res,$count,"dateline");
$title=mysql_result($res,$count,"title");
$pagetext=mysql_result($res,$count,"pagetext");
echo "<font size=2 link color=#FFFFFF vlink color=#FFFFFF alink=#f0f0f0><b>$title</b><br><font size=2>By <i>$username</i><br><font size=2 color=ffffff>$pagetext<br> <br>";
}
@mysql_select_db($database,$db) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor><br><br><br><center><font color=FFFFFF face=vernada size=6>Database Error</font></center></body></html>");
?>
How can I make the threads titel a link to the thread?
10-18-2003, 03:36 PM
Display of latest thread at homepage
Threaded Mode