kurbitur Posted November 14, 2011 Share Posted November 14, 2011 I´m making a news webpage with many categories like "Business", "local", "world", "sports", "Health", "travel" and so on.... I think the best way is that each cat. has it´s own table and in the CMS I can check (box) "make this article appear on frontpage" So the breaking news and most recent news on frontpage are talking records from all the 10 tables but only the one who are marked as "frontpage" how would the code be? like ("SELECT FROM 'news', 'business', 'local', 'world', 'sports', 'health', 'travel' IF COLUMN publish CONTAINS WORD 'frontpage'"); ... trying to figure it out - any suggestions? Quote Link to comment Share on other sites More sharing options...
QuickOldCar Posted November 14, 2011 Share Posted November 14, 2011 I guess you are looking for a "featured" article. If not you could always display just one of each category, and select by latest id or date. Quote Link to comment Share on other sites More sharing options...
kurbitur Posted November 14, 2011 Author Share Posted November 14, 2011 Hi thanx for the answer I´ll have the "latest from most of the catgories" but on the top are BREAKING NEWS and sometime if from "entertainment" is interesting I maybe want to make it "feature" Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.