|
 |
Due to the volume of spam happening on our forums, posting is now restricted to verified members only. If you're not verified, drop us a note with your username.
|
|
Home > FlexCMS Support Forum > User Help > General Support Requests > Latest forum posts
FlexCMS Support Forum
Latest forum posts
Started June 11, 2008 @ 6:15am by pebe
|
Post Message |
|
|
| Latest forum posts | June 11, 2008 @ 6:15am | Hi,
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: 625 |
|
|
| 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)) {
print '<a href="'.$MainURL.'/forum/'.$row['BoardID'].'/'.$row['RecordNumber'].'.html">'.$row['Title'].'</a><br>';
} |
|
David
FlexCMS v3.2 Has Been Released! |
|
|
|
Last Edit: June 11, 2008 @ 8:16am by DCSun | |
|
|
|
|
|
|
| MEMBERS
|
|
|
