Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[stephane]

Hello,
Is there any possibility to show in function Archives only ONE category ?
For example if I have 3 categories like CATEGO A, CATEGO B, CATEGO C with some different articles in it.
When we display Archives link, I want to see only the articles of the CATEGO B, and nothing else.
Do you think is that possible ?

Thanks
Stéphane

[Joost]

Here is a simple solution, but you will have to look for the category id (table categories) in the database.

In function archives(),  find the following line:

$query = "SELECT * FROM ".db('prefix')."articles WHERE position = 1 AND published = 1 ORDER BY date DESC";

replace it with the red, bold  (id) is the id, found in the database:

$query = "SELECT * FROM ".db('prefix')."articles WHERE category = (id)  AND position = 1 AND published = 1 ORDER BY date DESC";

[stephane]

Yes... That is the good solution.

Thanks a lot Joost (karma +1 

S.

[funlw65]

Another good solution
http://snewscms.com/forum/index.php?topic=5783.0

[Joost]

Another good solution
http://snewscms.com/forum/index.php?topic=5783.0

That's a menu.