Home N-13 News Forums Help Search
RegisterForgot password?
How to add image to post necklacesdiscou
Known bugs - 4.0.3 necklacesdiscou

Latest N-13 News 4.0.3

What is N-13 News?
Where can I get help?
Known bugs

Forums Help & Support How To show articles form just one category
1 2
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
1 2
Network-13.com © 2013