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
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
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]

$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 :rolleyes: Thanks Lee

It should be this

<?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.

[assassingod]

You can probably use the smallfont tag yes.

As for posts, I'll look into it

[assassingod]

Use this:

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

$latestthread=$DB_site->query("SELECT title,threadid,lastpost FROM thread ORDER BY lastpost 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]

cheers assassingod i have suzzed the posts out by ripping it out of another hack :)

i still cant get em to show in me frame in small font - it still shows em as big text even though ive used the <smallfont> command which looks untidy as i have it in an iframe and posts stretch over to 2 lines

[assassingod]

The code I posted above works perfectly for new posts;)

If smallfont doesnt work, youll have to use
<font size=\"2\"><a href=\"$bburl\showthread.php?s=$session[sessionhash]&amp;threadid=$latestthreads[threadid]\">$latestthreads[title]</a></font>