, Guest!
Already a Member? Login or Register.





Menu



Clients



Showcase



Rate FlexCMS

ScriptSearch.com Rating:

Hotscripts Rating
Excellent!
Very Good
Good
Fair
Poor

Scripts.com Rate Script!


FlexCMS eNews

To subscribe to our enewsletter, please enter your email address in the box below and click the "Subscribe" button.


Note:  You may easily remove yourself from the newsletter list at any time by following the instructions included with every mailing.

LATEST DEVELOPMENT NEWS:  FlexCMS 2.5 has been released!!! Click here to read the official announcement!

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: 392
 
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
 

Last Edit: June 11, 2008 @ 8:16am by DCSun

Post Message 




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

Processing Time: 0.11870 seconds.
 

Powered By FlexCMS
Powered By FlexCMS


Valid CSS!