Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules
Author Message
bizarre12
New Member
New Member



Joined: Mar 29, 2008
Posts: 22

PostPosted: Wed Apr 09, 2008 6:17 am Reply with quote

I'm wondering if there is a way to exclude single topic from the stories_archive page?

maybe with "if" rule inside index.php?

and the same in "Topics"
 
View user's profile Send private message
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Sun Apr 13, 2008 5:24 am Reply with quote

Absolutely, just check each sql statement that is being built with _stories in the table name (the FROM) and you could add to the WHERE clause a

" AND != '12'"

The example above is assuming you want to exclude topic id 12.

If you want to exclude multiple ones you might try this syntax instead:

" AND NOT IN ('12', '23', '2')"

This last syntax I know is possible in MySQL 5 and greater. Not sure on below that.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Modules

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©