show a news category's entries in page

[spida]

Hello!

I want to include a news category's entries in a page. I thought this might be accomplished with a code page.
I do use a code page on the site in order to display a certain page. The code I use is this one:

Code:

$pid = 2;
$gc = $database->query("SELECT content_long FROM ".TABLE_PREFIX."mod_news_posts WHERE post_id = ' ".$pid." ' ");
$rc = $gc->fetchRow();
echo $rc['content_long'];

I thought this could be a starting point and tried to use the group_id instead of the post_id:

Code:

$gid = 9;
$gc = $database->query("SELECT content_long FROM ".TABLE_PREFIX."mod_news_posts WHERE group_id = ' ".$gid." ' ");
$rc = $gc->fetchRow();
echo $rc['content_long'];

It doesn't work though, instead the first (the oldest) post of the category is displayed.

Does anyone have an idea on how to do this?

Cheers,
spida

[vyni]

I don´t know - but try

the snippet anynews with group defined instead.

get and install anynews, than call it like this
display_news_items(9);

regards from Himberg, next to Vienna

[Ruud]

Looking at your code you want to display one post.

Have you looked at this module?

Ruud

[spida]

@ruud: thank you. But I only display just one news on the startpage. Nevertheless your module will be helpful on this page

@vyni: thank you for the hint. I am using the snippet but experiencing extreme problems with it. See http://www.websitebaker2.org/forum/index.php/topic,409.msg71605.html#msg71605

cheers,
spida

[thorn]

Hello,

Code:

$gid = 9;
$gc = $database->query("SELECT content_long FROM ".TABLE_PREFIX."mod_news_posts WHERE group_id = ' ".$gid." ' ");
$rc = $gc->fetchRow();
echo $rc['content_long'];

Code:

$gc = $database->query("SELECT content_long FROM ".TABLE_PREFIX."mod_news_posts WHERE group_id = '$gid' ORDER BY position DESC LIMIT 1");

will do the trick.

thorn.

[spida]

Hi Thorn,

looking at your code I also thought it should work, but it doesn't. This is the complete code including your part:

Code:

$gid = 9;
$gc = $database->query("SELECT content_long FROM ".TABLE_PREFIX."mod_news_posts WHERE group_id = '$gid' ORDER BY position DESC LIMIT 1");
$rc = $gc->fetchRow();
echo $rc['content_long'];

I can't see what the problem might be...   

Cheers,
spida

[Ruud]

Just tried this code in a codepage and it works fine.
The only reason I can think of is that you are not using the correct $gid.

So what exactly doesn't work for you?

Ruud

[spida]

Hi,

I checked the group id, it's correct (still number 9). There's just nothing displayed. I thought it might be a conflict with the anynews module and uninstalled it, but this didn't help either.

Do you have any further suggestions?

Cheers,
spida

[Ruud]

Hmm..

Why don't you use the module I mentioned earlier. http://www.websitebaker2.org/forum/index.php/topic,11523.0.html
It does exactly what you are trying to do here, only it will respect the other news flags (publish dates.. active/inactive flag).
Plus.. you can select the group from a pull down list.
Instead of your code section use a "Latest News" section.

For the rest..
I can imagine CSS problems (just like in your post about the anynews snippet i would suspect a <pre> tag).
Can we heave a look at your page? (is it remotely accessible?)

Ruud

[spida]

Hi Ruud,

problem is, that your module only shows one news (i.e. the latest news of either a specific category/group or the latest news of all news).

What I need is a page that displays all the news of a specific group.

Thus I still think the code page should do, but it just doesn't bring up a result. There is no reason to suspect the CSS, since conflicts with it wouldn't result in no data display, rather in wrong data display.

(Nevertheless, I like your module for my first page. Since I have a question about it, please see http://www.websitebaker2.org/forum/index.php/topic,11523.0.html)

Any further help with the code is very welcome. The page in question is not publicly accessable, alas.

Cheers,
spida

[Ruud]

The code examples in this thread will show only one post.
You would need some extra coding to show all posts. Also you would probably want to see the title of the post too..

Since nothing is shown at all, you might want to go back to step one:
try in your code section something simple like

Code:

echo "Hello world";

and see if that displays.

Ruud

[spida]

Hi Ruud,

looks like we're the only ones in these two topics 
Hello world is perfectly shown.

best,
spida