https://proxy2.de/forum/posts/list/2.php JForum - http://www.jforum.net
i noted that in the front page you have a small extract of live stuff from the forums - the newest topics and an abstract of the messages.

will you please tell me how to put it on my site too, i would just love to have it.

thanks a lot.]]> https://proxy2.de/forum/posts/preList/448/1138.php https://proxy2.de/forum/posts/preList/448/1138.php GMT
[code]
<?php
include "$HTTP_SERVER_VARS[DOCUMENT_ROOT]/forum/config.php";
$ShowLimit = 2;
$text_lenght = 68;

$connect_id = @mysql_connect($dbhost,$dbuser,$dbpasswd);
if ($connect_id) {
mysql_select_db($dbname,$connect_id);
$sql = "SELECT
a.post_time, a.post_username, b.post_subject, b.post_text
FROM
".$table_prefix."posts a, ".$table_prefix."posts_text b
WHERE
a.post_id=b.post_id
ORDER BY
a.post_time DESC limit $ShowLimit";

$result = mysql_query($sql,$connect_id);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
$BODY = substr($row['post_text'],0,$text_lenght)."...";
$DATESTAMP = date("d-M-Y H:i",$row['post_time']);

echo "<span class=\"ForumLink\">$row[post_subject]</span><br>
<u>Posted on $DATESTAMP</u><br>$BODY<br><br>";
}
mysql_close($connect_id);
}


?>
[/code]]]> https://proxy2.de/forum/posts/preList/448/1163.php https://proxy2.de/forum/posts/preList/448/1163.php GMT