Welcome to Geeklog, Anonymous Saturday, April 18 2026 @ 10:49 pm EDT

Comments for Latest Stories in a Block

Latest Stories in a Block | 7 comments | Create New Account

The following comments are owned by whomever posted them. This site is not responsible for what they say.

Latest Stories in a Block

Authored by: mrb42 on Friday, November 12 2004 @ 10:30 am EST

Thanks!


$numStories = 10;
    $result = DB_query("Select sid, title,unix_timestamp(date) AS day FROM {$_TABLES['stories']} WHERE (date <= NOW()) AND (draft_flag = 0) ORDER BY date DESC LIMIT $numStories");
    $nrows = DB_numRows($result);
    for ($i = 1; $i <= $nrows; $i++) {
        $A = DB_fetchArray($result);
        $retval .=  date("M d",$A['day']) . ' -- <a href="' . $_CONF['site_url'] . '/article.php?story=' . $A['sid'] . '">' . stripslashes($A['title']) .  '</a><BR>';
}
    return $retval;

This is the final version for my site... check it out in action at Northeast Ohio Music

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks