Welcome to Geeklog, Anonymous Saturday, July 11 2026 @ 01:38 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 @ 09:22 am EST

I don't use the groups, so it wasn't needed for my site... and as soon as I can figure out how to reformat the date I'm going to add it back (I'm a newb to PHP), I just want the Mon-DD (like the Older Stories Block) instead of the full timestamp...

Latest Stories in a Block

Authored by: tomw on Friday, November 12 2004 @ 10:03 am EST

In my original query I had:

unix_timestamp(date) AS day

That was for a situation like this. Then you could use

date("M d",$A['day']) and it would be formated like

Nov 12

Look at the date function in php for other variations.

Tom

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