How To show articles form just one category

Chris

Posted on 02 Mar 2011, 18:43:25

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Try "DESC" instead.

#3292

Dla86

Posted on 02 Mar 2011, 18:47:48

Access: Member
Total Posts: 21
Joined: 2011-02-10

nothing...

#3293

Chris

Posted on 02 Mar 2011, 18:49:57

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

My mistake, this should work

Code:


$newsarticles = DataAccess::fetch(sprintf("SELECT title, story, shortstory, id FROM %s WHERE id IN (SELECT storyid FROM %s WHERE catid = ?) ORDER BY id DESC", NEWS_ARTICLES, NEWS_GROUPCATS), $categoryid);

#3294

Dla86

Posted on 02 Mar 2011, 18:58:16

Access: Member
Total Posts: 21
Joined: 2011-02-10

thanks, it works!!
tomorrow I'll make a donation :)

#3295

Dla86

Posted on 03 Mar 2011, 06:15:54

Access: Member
Total Posts: 21
Joined: 2011-02-10

One last question... Is it possible to change the order of articles?

#3298

Chris

Posted on 03 Mar 2011, 17:14:27

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Have a look at this page

http://code.google.com/p/n-13news/wiki/Integration

#3304