Last new posts

[lasto]

i want to show the last 20 posts made on the forum on a seperate page does anyone have an idea on how to do this ??

[assassingod]

I think it will be something like this.

PHP Code:

<?php
error_reporting(7);
require('./global.php');

$latestthread=$DB_site->query_first("SELECT title,threadid,dateline FROM thread ORDER BY dateline desc LIMIT 20");

    echo ("Latest 20 threads: <br /> <a href=\"showthread.php?s=$session[sessionhash]&amp;threadid=$latestthread[threadid]\">$latestthread[title]</a>");


?>

Untested, should work. If it doesn't, i'll look further into it

[lasto]

u nearly there m8

i get a Warning: Cannot modify header information - headers already sent by (output started

then it shows one new post underneath it

[lasto]

ok i took out the error reporting bit

and no error now but it only shows one post still

[assassingod]

Try

PHP Code:

<?php 
error_reporting(7); 
require('./global.php'); 

$latestthread=$DB_site->query_first("SELECT title,threadid,dateline FROM thread ORDER BY dateline DESC LIMIT 20"); 

    echo ("Latest 20 threads: <br /> <a href=\"showthread.php?s=$session[sessionhash]&amp;threadid=$latestthread[threadid]\">$latestthread[title]</a>"); 


?>

[lasto]

same m8

no error but only one latest thread/post is showing

[NTLDR]

$DB_site->query_first() will only return one result, no matter now may rows you tell it to fetch from the DB. You need to use $DB_site->query() and use $DB_site->fetch_array() in a while loop to get more than one item from the DB.

[assassingod]

Originally Posted by NTLDR

$DB_site->query_first() will only return one result, no matter now may rows you tell it to fetch from the DB. You need to use $DB_site->query() and use $DB_site->fetch_array() in a while loop to get more than one item from the DB.

Duh, I am an idiot Thanks Lee

It should be this

PHP Code:

<?php
error_reporting(7);
require('./global.php');

$latestthread=$DB_site->query("SELECT title,threadid,dateline FROM thread ORDER BY dateline DESC LIMIT 20");
    while ($latestthreads=$DB_site->fetch_array($latestthread)) {
    echo ("<a href=\"$bburl\showthread.php?s=$session[sessionhash]&amp;threadid=$latestthreads[threadid]\">$latestthreads[title]</a><br /> ");
}

?>

[lasto]

works perfect

can i use <smallfont> in a php file to make text a lot smaller ?
also thanks to assassingod and NTLDR

[lasto]

sorry one final question

i knwo u helped enough but the above is fine but it only gets new threads dont it,how can i do the exact same but for posts.