webhost:
PHP Code:
<?php
error_reporting(7);
require("./global.php");
$latestposts=$DB_site->query("SELECT post.postid AS id,LEFT(post.pagetext,20) AS text FROM post LEFT JOIN thread ON thread.threadid WHERE thread.forumid<>14 AND thread.forumid<>43 AND thread.forumid<>87 GROUP BY post.postid ORDER BY post.dateline DESC LIMIT 10");
$marquee = "";
while ($latestpost=$DB_site->fetch_array($latestposts)) {
if ($marquee) {
$marquee .= " "; // String to seperate between each link
}
$marquee .= "<a href=\"showthread.php?s=$session[sessionhash]&postid=$latestpost[id]\">$latestpost[text] ...</a>";
}
?>
<? echo("$marquee"); ?>
(working)