tboogie937 Posted February 7, 2009 Share Posted February 7, 2009 I'm trying to display certain topics on my homepage, from my phpbb forum. I want to exclude forums 46, 47, & 48 from being displayed, however I am running into trouble with the line that reads t.forum_id != 46 AND from the following code... <?php // How Many Topics you want to display? $topicnumber = 5; // Change this to your phpBB path $urlPath = "/forums"; // Database Configuration (Where your phpBB config.php file is located) include 'forums/config.php'; $table_topics = $table_prefix. "topics"; $table_forums = $table_prefix. "forums"; $table_posts = $table_prefix. "posts"; $table_users = $table_prefix. "users"; $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect"); mysql_select_db("$dbname") or die("Could not select database"); $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username FROM $table_topics t, $table_forums f, $table_posts p, $table_users u WHERE t.topic_id = p.topic_id AND f.forum_id = t.forum_id AND t.forum_id != 46 AND t.topic_status <> 2 AND p.post_id = t.topic_last_post_id AND p.poster_id = u.user_id ORDER BY p.post_id DESC LIMIT $topicnumber"; $result = mysql_query($query) or die("Query failed"); print "<table cellpadding='3' cellSpacing='2' width='350'>"; while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "<tr valign='top'><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#FFCC00\"><b><a href=\"$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]\" TARGET=\"_blank\">" . $row["topic_title"] . "</a></td></font></b><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#C0C0C0\"> by: <a href=\"$urlPath/memberlist.php?mode=viewprofile&u=$row[user_id]\" TARGET=\"_blank\">" . $row["username"] . "</td><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"><font color=\"#C0C0C0\">" . date('F j, Y, g:i a', $row["post_time"]) . "</td></tr></font>"; } print "</table></marquee>"; mysql_free_result($result); mysql_close($link); ?> Please help! Thank you Quote Link to comment https://forums.phpfreaks.com/topic/144256-phpbb-topic-display-script/ Share on other sites More sharing options...
tboogie937 Posted February 8, 2009 Author Share Posted February 8, 2009 Help... anyone? please Quote Link to comment https://forums.phpfreaks.com/topic/144256-phpbb-topic-display-script/#findComment-757143 Share on other sites More sharing options...
npsari Posted February 8, 2009 Share Posted February 8, 2009 Try this link tell me if you have any difficulties http://www.zortin.com/scripts/show/?id=316 To ignore a row, simply say WHERE t.forum_id ! = '46' Quote Link to comment https://forums.phpfreaks.com/topic/144256-phpbb-topic-display-script/#findComment-757158 Share on other sites More sharing options...
acctman Posted February 8, 2009 Share Posted February 8, 2009 Try this link tell me if you have any difficulties http://www.zortin.com/scripts/show/?id=316 To ignore a row, simply say WHERE t.forum_id ! = '46' what version of PHPbb is that for 2 or 3? Quote Link to comment https://forums.phpfreaks.com/topic/144256-phpbb-topic-display-script/#findComment-757276 Share on other sites More sharing options...
tboogie937 Posted February 8, 2009 Author Share Posted February 8, 2009 Try this link tell me if you have any difficulties http://www.zortin.com/scripts/show/?id=316 To ignore a row, simply say WHERE t.forum_id ! = '46' what version of PHPbb is that for 2 or 3? PHPBB3 I want to ignore not just a row, but 3 rows. When I use WHERE t.forum_id ! = '46,47,48' it only ignores the first number (46), and not the others. Quote Link to comment https://forums.phpfreaks.com/topic/144256-phpbb-topic-display-script/#findComment-757389 Share on other sites More sharing options...
alphanumetrix Posted March 5, 2009 Share Posted March 5, 2009 try using AND: where t.forum_id!='46' AND t.forum_id!='47' AND t.forum_id!='48' Quote Link to comment https://forums.phpfreaks.com/topic/144256-phpbb-topic-display-script/#findComment-777230 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.