Welcome to Geeklog, Anonymous Tuesday, April 23 2024 @ 01:25 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

Warning: Javascript required to enable functionality

Post a Comment

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