, Guest!
Already a Member? Login or Register.

Menu



Showcase


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 
pebe


Posts: 3
 
Latest forum postsJune 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

Post Message 




Try & Buy FeedForAll - Easy to use RSS Feed Creator - great for iTunes users!

MEMBERS




All Contents, Code, Scripts and Technologies Copyright 2003-2009 FlexCMS.
All Rights Reserved. Software License Agreement

Processing Time: 0.07234 seconds.
 
Management Login

Powered By FlexCMS
Powered By FlexCMS