Displaying all stories from 1 category

[Laurent]

Hey
I'm not good at php at all and can't figure out how to code the following:
display ALL (all time) stories (queued, published, etc) from 1 given category, ordered by most votes.
I hope anyway could help me with this..
thank in advance

[savant]

what page are you planning to display the stories.

first you'll need to get the category id.

select category_id from categories where category_safe_name = 'pligg'

once you have the category id you can find all the stories

PHP Code:

$links = $db->get_col("select link_id from links where link_category=$category_id order by link_votes desc");
if($links){
        $story = new Link;
        foreach($links as $link){
            $story->id = $link;
            $story->read();
                }
} 


the read will retrieve all the story data, and you can assign the values to smarty.

maybe if you can say more about what the page is, i can give you some code snippets to play with

[Laurent]

It does not seem to work when using this:

PHP Code:

$links = $db->get_col("select link_id from links where link_category=1 order by link_votes desc");
if($links){
        $story = new Link;
        foreach($links as $link){
            $story->id = $link;
            $story->read();
                }
} 


But(!) I forgot to mention that I am using Meneame, not sure if that will affect the coding?

[savant]

I'm sorry i haven't looked at the meneme code, and not sure if it has a database object.

Best advice is to contact one of their developers or support forum.

[Laurent]

Originally Posted by savant

I'm sorry i haven't looked at the meneme code, and not sure if it has a database object.

Best advice is to contact one of their developers or support forum.

Alright, thanks for the help anyway :)

[j_esq]

can this go in the index.php file or should it go in the index_center.tpl

[noyp]

has this been sorted out?

anyone solved this... ;)