I'm using some code (see below) that I found on the forum to display all postings from the forum.
How can I create this list withoud the content of the posts? I'd only like to see the headings and a way to limit to only see the the last 10 new posts?
Best regards, Peter www.inspired-divers.be
// Code
$query = "select * from `".$Settings['DBPrefix']."mb-Settings`"; $result = mysql_query($query) or die (mysql_error()); while ($row = mysql_fetch_array($result)) { $mbSettings[$row['Name']] = $row['Value']; }
include_once('./inc-mb-recent.php');
print $PageContents; //
DCSun Administrator
Posts: 611
June 11, 2008 @ 8:15am
Peter,
Probably the easiest way would be to just run a query on the table that contains the message board threads, then you can create the output to suit your needs. Something like this should get you started:
Code
$query = "select * from `".$Settings['DBPrefix']."mb-Threads` order by LastReply desc limit 10"; $result = mysql_query($query) or die (mysql_error()); while ($row = mysql_fetch_array($result)) {
