Welcome to Geeklog, Anonymous Tuesday, December 16 2025 @ 11:20 am EST

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 Thursday, November 11 2004 @ 08:21 am EST

For some reason, this wasn't quite working for me... no errors, but the links weren't working, so I did a slight rewrite and simplified it a bit.


    $numStories = 10;
    $result = DB_query("Select sid, title,date 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 .= '<a href="' . $_CONF['site_url'] . '/article.php?story=' . $A['sid'] . '">' . stripslashes($A['title']) .  '</a><BR>';
}
    return $retval;

Latest Stories in a Block

Authored by: tomw on Thursday, November 11 2004 @ 09:40 am EST

The reason the links weren't working was that the version I had used the url-rewriting form of the link. Apparently your server does not support this.

You also removed the date of the story. The other thing you removed is the security check, so that all stories are available for all users.

Thanks for sharing your changes for others to use.

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