How do I add the latest posts to my website homepage?

[FPR]

Looking to add the most recent forum posts to my homepage. Any ideas how?

Cheers
FPR

[mescalin]

i need that mod really urgent

[sebbe]

What type of homepage is it?

Assuming it's a non-vB one:

PHP Code:

$conn = mysql_connect("localhost", "username", "password") or die(mysql_error());
$query = "SELECT pagetext FROM post ORDER BY dateline DESC LIMIT 1";
$result = mysql_query($query) or die(mysql_error());

while (list($pagetext = mysql_fetch_array($result)))
{
    echo $pagetext;
} 


Please note that this is the simplest possible way and will only output the latest post text and nothing else. You might have to add a table prefix also if you use any.

[mescalin]

thanks, i will try that..

but i couldnt understand why vb doesnt have a latest post mod, i was using invision and there were many mods for the same job. i have searched the forum many people are lookng for that but there isnt.. is editing vb harder than invision? :/

[sebbe]

I don't know if such a mod exist, but I would think that it's difficult to meet everyones needs, everone want the output in a different way.
Therefore, it's best to do this by your own. It's not very hard.

[mescalin]

i searched 3.6x mods but i couldnt find, its the most common mod in every forum sytem i hope there is one but i cant find.. Im not a coder so i cant write just waiting for a coder to develop it..

Thank you for your code again i will use that..

[sebbe]

What was that mod called on ipb? Maybe you can provide a link to it so I can see how it works?

[Chicago_VLNU_4s]

Originally Posted by sebbe

What type of homepage is it?

Assuming it's a non-vB one:

PHP Code:

$conn = mysql_connect("localhost", "username", "password") or die(mysql_error());
$query = "SELECT pagetext FROM post ORDER BY dateline DESC LIMIT 1";
$result = mysql_query($query) or die(mysql_error());
 
while (list($pagetext = mysql_fetch_array($result)))
{
    echo $pagetext;
} 


Please note that this is the simplest possible way and will only output the latest post text and nothing else. You might have to add a table prefix also if you use any.

doesnt work, it just displays that whole code on my homepage template

[sebbe]

Originally Posted by Chicago_VLNU_4s

doesnt work, it just displays that whole code on my homepage template

You need to put "<?" or "<?php" around the code.

PHP Code:

<?
$conn = mysql_connect("localhost", "username", "password") or die(mysql_error());
$query = "SELECT pagetext FROM post ORDER BY dateline DESC LIMIT 1";
$result = mysql_query($query) or die(mysql_error());
 
while (list($pagetext = mysql_fetch_array($result)))
{
    echo $pagetext;
}
?>

Also, don't forget to change the strings "username" & "password"

[Chicago_VLNU_4s]

sorry, still kinda new to this.. but what do you mean "change the strings" for username and password?

-thanks