searching & tagged content on index page

I'd like to show the articles no matter what section they were posted to - so if I posted articles this week on Tuesday, Sept. 9 in several section editors, I would have only these articles show up in the "what's new" section on the index page. Then, the next week I'd change the code on the index page to only show the articles posted on Tuesday, Sept. 16, etc.

I know there's the feature to show only the last few articles, or the latest articles, but I don't want that. I'll have a date field and want to be able to say "I only want the article's title and summary from Sept. 9, from anywhere on the website, to show up on the index page" and there would be a link to the article wherever it is on the website.

I may have grasped this wrong but wouldn't a search based on the number of days from today work for this. Perhaps have code take todays date minus 7 and then display all new articles.

Mickey

Would there be a way to just put a date, like "september 2" in the code, and then it would show all the articles on the index page, no matter which section editor they're in?. I will have a date field, and the code would pull up all the articles that have the date.

I would leave the same code in the index page, but just change "september 2" to the next week's date, pulling new articles into my "what's new" section.

The only problem is I know nothing of coding so could somebody show me what to put and where to put it - I'm great at cut and paste [:)]

The multi-table search feature (multiSearch) is pretty basic. So it doesn't let you search like there.

What you'd need to do (and would probably be a better way to organize things anyway) would be to have all your articles in one section with a pulldown for "category". Then you'd have a where like this:

where => " category = 'music' AND DATE_FORMAT(yourDateField, '%Y-%m-%d') = '2008-09-08' ",

It's a bit advanced, and need that mysql code above, but it should work.

Hope that helps!

thanks! I got the search working.

So, instead of having separate section editors for the different subjects like I normally do, I'll have all the different subjects in ONE section editor as separate categories? With different articles under these separate categories?

If that's the case, what code would I use to put separate categories on separate pages? - instead of Admin > Code Generator > select section as I normally put each section editor on a different page, how do I now put the different categories on separate pages?

If this is the only way to do it, no problem. But for me it would be easier to do it the regular way of separate section editors (it would be easier I think to keep track of all the content instead of having all the items listed under one category)

To make sure I understand, there's no way to pull all the articles with the same date from all the section editors in the database and put them on the index page in a "what's new" section? I'll have to go the route of putting them all in one category section editor?

You add this code in the code generator under: "Advanced: Only show results that match this MySQL "Where" clause:"

Just enter your category name like this:
category = 'music'

Another way to do the same thing is just add it to the code like this:
where => " category = 'music' ",

And to confirm, no, there's no easy way to pull articles from multiple sections and then filter them by date. There's ways to do it, but they involve pretty complex SQL.

Hope that helps, let me know if you need more help with that.

I don't want to bring up dates by category, I want to bring up dates under the entire section editor table. This is what i have now and it's working, but not what I want:

<?php

require_once "/home/content/h/e/a/hearts2god/html/cmsAdmin/lib/viewer_functions.php";

list($resourcesRecords, $resourcesMetaData) = getRecords(array(
'tableName' => 'resources',

where => " category = 'music' AND DATE_FORMAT(date, '%Y-%m-%d') = '2008-09-16' ",

so, I don't want articles dated the 16th from JUST music, I want all the articles in the tableName resources. How would I write that?

How about this?

where => " DATE_FORMAT(date, '%Y-%m-%d') = '2008-09-16' ",

We're just removing the category = 'music' part. Would that work for you?