Display of latest thread at homepage [Archive]

Bonee70

10-18-2003, 03:36 PM

Ive found a small script

<?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> <center>Database Error</center></body></html>");
@mysql_select_db($forum_database,$forum_db) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor> <center>Database Error</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 "$title By $username $pagetext    ";
}

@mysql_select_db($database,$db) or die("<html><head><body bgcolor=$bgcolor alink=$bglinkcolor vlink=$bglinkcolor link=$bglinkcolor> <center>Database Error</center></body></html>");
?>

How can I make the threads titel a link to the thread?

sabret00the

10-18-2003, 03:45 PM

you'd be better of going with tubedogg's one :)

search for "last10 non-vb"

Bonee70

10-18-2003, 04:40 PM

TY, but I cant get this hack to work, I cant even see it in action anywhere.

All I need it a solution to make the thread titel a link plz....

Bonee70

10-18-2003, 06:36 PM

OK, Ive managed to get the recommend hack to work, ty.