searching & tagged content on index page

Hi kapelle,

Thanks for posting!

Let me address your questions one at a time:

1. Is it possible to do a search on the entire website and display the results, or can you only search one section editor at a time?

You can do either type of search - it's up to you! To set up a search page that accesses multiple sections, you'll want to download the multiSearch.php file in this forum post:

http://www.interactivetools.com/iforum/gforum.cgi?post=61466;search_string=multisearch;t=search_engine#61466

For instructions on setting up a regular search for a single section, you can visit this page of the documentation:

http://www.interactivetools.com/docs/cmsbuilder/viewer_search.html

2. Each section will have several articles, with new content added each week. Let's say I put a new article in each section on a Monday. Is it possible to tag all the articles by date, then have only the articles from every section tagged by the same date (Monday) appear on the index page, like in a "what's new" section?

For this, were you looking to always show the latest article from each section, or were you looking to always show the most recent articles, regardless of the section they were added to?

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?