add recently added posts etc to front page

[tbobker]

I am running a forum and now want to create another front / homepage where i can have other stuff related to the site as well as displaying recently added posts from the forum.

I have looked in the database for some sort of date or time that a certain post has been posted but doesnt make sense, it doesnt look like a sort of time and date that is humanly readable?

Any ideas?

[Weedpacket]

I certainly can't read it. I wonder why that is?

[Ausx]

It would depend on what forum system you're using. If for example it's PhpBB you could try running this:

$sql = "SELECT `post_text`
           FROM `phpbb_posts_text`
           ORDER BY `post_id` DESC
           LIMIT 0 , 5";
$qry = mysql_query($sql) or die ("error");
$txt = mysql_fetch_row($qry);

$loop = 0;
while ( 5 > $loop) {
    echo $txt[$loop] . '<br />';
    $loop++;
}

That would print out the last 5 posts.

[tbobker]

i am running an smf forum, and the table with all the posts inside is called smf_messages, one field is called posterTime and the time format is as follows;

1152224273
1152224366
1152224434
..etc

any ideas?

[etully]

That's the number of seconds since Midnight, Dec 31, 1969. Check out the date() function at php.net.

[tbobker]

ok i have found LIMIT as an sql command, but how can i say the last 10 posts / inserts rather than from 0, 10? Rather from the last post and 10 back.

[SpecialFX]

Why not just this..

 $sql = "SELECT `post_text`
           FROM `phpbb_posts_text`
           ORDER BY `post_id` DESC
           LIMIT 10";