Your code worked, thank you.

For the record, here is what I did for an automatic archive news item page and the detail page - the code  below is for my LIST page.

// load records from 'notices_srpc'
list($notices_srpcRecords, $notices_srpcMetaData) = getRecords(array(
'tableName' => 'notices_srpc',
'loadUploads' => true,
'allowSearch' => false,
'ignoreRemoveDate' => true,
'where' => "`publishDate` < '".date('Y-m-d H:i:s', strtotime('-1 year'))."'"

));

Then, in order to be able to use the same Detail page as my current news listings, I used this code for the detail page. The key was to use the ignoreRemoveDate.  This is the active page  http://strafford.org/newsarchiveList.php

list($notices_srpcRecords, $notices_srpcMetaData) = getRecords(array(
'tableName' => 'notices_srpc',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
'ignoreRemoveDate' => true,
));
$notices_srpcRecord = @$notices_srpcRecords[0]; // get first record

I would like to do exactly what mizrahi, requested in this Post 2234008 [https://www.interactivetools.com/forum/forum-posts.php?postNum=2234008#post2234008]

My url for the test News Archive page is :  http://strafford.org/newsarchiveList.php

Current news items are shown on the home page of http://strafford.org and on this page http://strafford.org/notices.php 

Using the same table "notices_srpc" which holds news items, I would like to have items older than a year appear on another page "newsarchiveList.php" 

When I add Greg's suggested code from Post 2234008 for s separate listing of items a year old, as below, the page does not appear at all.

// load records from 'notices_srpc'
list($notices_srpcRecords, $notices_srpcMetaData) = getRecords(array(
'tableName' => 'notices_srpc',
'loadUploads' => true,
'allowSearch' => false,
'where' => "`createdDate` < '".date('Y-m-d H:i:s', strtotime('-1 year'))."')"
'ignoreRemoveDate' => true,
));

If the 'ignoreRemoveDate' is removed from the above, I get an error message as follows:

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND `notices_srpc`.hidden = 0 AND `notices_srpc`.publishDate <= NOW() AND (`no' at line 3

I noticed a forum post from a user in Post 2235844 https://www.interactivetools.com/forum/forum-posts.php?postNum=2235844#post2235844 that they  received this kind of message after a server move.

Indeed after the CMSB was updated by you guys (thanks again) this site was recently moved to a new and better host. I suspect, however, that the where query isn't structured correctly.

I have left the test page (http://strafford.org/newsarchiveList.php) showing the error message. The code on it is:

// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/usr/home/straffordrpc/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records from 'notices_srpc'
list($notices_srpcRecords, $notices_srpcMetaData) = getRecords(array(
'tableName' => 'notices_srpc',
'loadUploads' => true,
'allowSearch' => false,
'where' => "`createdDate` < '".date('Y-m-d H:i:s', strtotime('-1 year'))."')"
));

So in summary, can you help me get a News Archive List page showing items over a) 6 months old and b) over 1 year old? (The client can choose which range they want.)

I am assuming that the same Detail page can be used with both the Current News items and with the Archived News items.

Thanks in advance, J

Note: this site Running CMSB 3.10  and PHP v7.1.15 

Thanks very much, J

The client wanted to have the maps page accessible, so I made a new development page here:

http://strafford.org/maps/standmapsListdm.php

The Aerial maps category has a demo jumpmenu /dropmenu.

But to return to my point above, I would like to avoid js/jquery connections and use a form with a jump menu. I think my client's users will be more comfortable with that as well. Is this possible?

I set one up on the development page as below, but I know there is something missing.

<form name="form" id="form">
<select name="jumpMenu" id="jumpMenu" onChange="MM_jumpMenu('parent',this,0)">
<option value="" selected>Select</option>

<?php foreach ($standmaps_2015_aerialRecords as $record): ?>
<option value="<?php echo htmlencode($record['townaerial15']) ?>"><?php echo htmlencode($record['townaerial15']) ?></option>
<?php endforeach ?>
</select>
<input type="submit" name="go_button" id="go_button" value="Go" onclick="MM_jumpMenuGo('jumpMenu','parent',0)" />
</form>

thanks, J

Before I get into the weeds of using javascript for this (my scripts are all related to the menu systems I use), why can't I just use the jumpmenu method similar to that discussed in this post: "A drop-down year list to display different categories books."  http://www.interactivetools.com/forum/forum-posts.php?A-drop-down-year-list-to-display-different-categories-books.-78685

Here is that code from that post...

<form method="get" action="birds_mag_list.php" >
   <?php $options = getListOptions('birds_mag_list', 'list'); ?>
     <select name="list">
       <option value="">&lt;select&gt;</option>
          <option value="">Any</option>
            <?php foreach($options as $value => $label): ?>
          <option value="<?php echo $value; ?>" ><?php echo $label; ?></option>
     <?php endforeach; ?>
    </select>
   <input type="submit" name="go_button" id="go_button" value="Go" onclick="MM_jumpMenuGo('jumpMenu','parent',0)" />
</form>

best, J

Success on part one! I have all the sections reading properly on the Map Index page and all the links connect properly to a Detail page.  I made a simplified version of the page (removing global nav) and it is viewed here 

http://strafford.org/maps/standmapsList.php

and the code is uploaded as an attachment - both as the page above and in a 'simple' version cleaning out scripts, etc.

I am looking forward to learning how to program the dropdowns and the client is excited - many months of work on their part for this.

Best, J

I am creating a page for a planning commission's maps. They are offering different map types for download, e.g. aerial, land use, transportation.

I need a index showing the many type of maps available and I am creating a List page with multiple viewers.  

Each map viewer will have a drop down menu (or jump menu) where a town name can be selected.

The site visitor selects a town name and then will go to a Detail page where they can download the map and see more information about the map.

An html List page with the layout I want is here:  http://strafford.org/maps/standmapsList.html

An html Detail page is here. http://strafford.org/maps/standmapsDetaillanduse.html

Even after extensively reviewing forum posts, I am unable to

1) load the multiple viewers on the index page.  My attempt is here:  http://strafford.org/maps/standmapsList.php

2) I am also unable to get the town names in the database to appear in a dropdown menu or jump menu).

My attempt at the List page using three section viewers is not working.  As others have experienced, I only see one viewer and the error "Unknown optionsType"

The List viewer page with php is here:  http://strafford.org/maps/standmapsList.php

So I need help with the multiple viewers on the Map listing page and I need help forming a jump menu or dropdown menu that is populated from the town field in the database.

No doubt I have some important code lines, but at this point I feel  am creating a  three ring circus. The Detail pages are working correctly at least.

Thanks in advance for your help. J

Code for List viewer page with php is below:

-------------------- header --------------------
<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
   require_once "/home/straffor/public_html/cmsAdmin/lib/viewer_functions.php";

// load viewer library
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('/home/straffor/public_html/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }
    
   // load records from 'standmaps_2015_aerial'
  list($standmaps_2015_aerialRecords, $standmaps_2015_aerialMetaData) = getRecords(array(
    'tableName'   => 'standmaps_2015_aerial',
    'loadUploads' => false,
    'allowSearch' => true,
  ));
 
  // load records from 'standmaps_2015land'
  list($standmaps_2015landRecords, $standmaps_2015landMetaData) = getRecords(array(
    'tableName'   => 'standmaps_2015land',
    'loadUploads' => false,
    'allowSearch' => false,
  ));
 
// load records from 'standmaps_transport'
  list($standmaps_transportRecords, $standmaps_transportMetaData) = getRecords(array(
    'tableName'   => 'standmaps_transport',
    'loadUploads' => false,
    'allowSearch' => false,
  ));
?>

-------------------- end header --------------------------------

-------------------- code with dropdown menus --------------------


     <h3>2015 Aerial </h3>
   
            <form method="get" action="standmaps_2015_aerial.php" >

              <?php $options = getListOptions('standmaps_2015_aerial', 'townaerial15'); ?>

             <select name="<?php echo htmlencode($standmaps_2015_aerialRecord['townaerial15']) ?>">

               <option value=""></option>

            <option value="">Any</option>

            <?php foreach($options as $value => $label): ?>

           <option value="<?php echo $value; ?>" ><?php echo $label; ?></option>

             <?php endforeach; ?>

            </select>

               <input type="submit" name="go_button" id="go_button" value="Go" onclick="MM_jumpMenuGo('jumpMenu','parent',0)" />
            </form>
            
-------------------- end code with dropdown menus --------------------       

This would cut off the text in a summary-type box at a fixed number of characters when a field is being displayed.

I could create a dedicated summary field and only display that in List View, but I think the client would prefer not to have an extra field to fill out.

I think there is a simple 'limit' command to enter, thanks in advance,

J. 

Also, is this something the Permalinks plug in can do more easily.

I know there is a simple htaccess step, but I can't find the authoritative way to do it with cmsb. 

This client has great seo for their products with the .html and I don't want to interfer with that.

J.