Clients are sometimes a pain, but where we would we be without them!
I have a request from my client to make a change to the dropdown menu. What he wants to see on the menu are the following:
squadron (currently there)
number of articles under 3 days old for the squadron
total number of articles for the squadron
in this format [ie. 537 Gander (3/7) ]
Here is the code I am using:
// load list records from 'squadron_news'
list($squadron_newsRecords, $squadron_newsMetaData) = getRecords(array(
'tableName' => 'squadron_news',
'loadUploads' => true,
'allowSearch' => true,
'orderBy' => 'publishDate DESC',
));
and
<div id="contentContainer"><!-- Start main content wrapper -->
<div id="content"><!-- Start content -->
<h2>Squadron News</h2>
<?php if (@$_REQUEST['squadron']): ?>
<br/>
<?php foreach ($squadron_newsRecords as $record): ?>
<br />
<h2><?php echo htmlencode($record['title']) ?></h2>
<b>Squadron</b>: <?php echo $record['squadron:label'] ?><br/>
<?php echo $record['content']; ?>
<ul>
<?php foreach ($record['documents'] as $index => $upload): ?>
<li><a href="<?php echo $upload['urlPath'] ?>"><?php echo $upload['info1'] ?></a></li>
<?php endforeach ?>
</ul>
<hr/>
<?php endforeach ?>
<?php if (!$squadron_newsRecords): ?>
No records were found!<br/><br/>
<?php endif ?>
<?php endif ?>
</div><!-- End content -->
<div class="clearer"></div>
</div><!-- End main content wrapper -->
<div id="sidebarContainer">
<div id="subMenu"></div>
<div class="clearer"></div>
<div id="sidebarHeader"></div>
<div id="sidebar">
<br />
<form name="choose" action="" method="get">
Choose a squadron:
<select name="squadron" size="25" style="width: 220px;">
<?php foreach (getListOptions("squadron_news", "squadron") as $value => $label): ?>
<option value = "<?php echo $value;?>" <?php selectedIf($value, @$_REQUEST['squadron']);?>><?php echo htmlspecialchars($label);?></option>
<?php endforeach; ?>
</select>
<input type="submit" value="Submit">
</form>
</div>
</div>
--
northernpenguin
Northern Penguin Technologies
"Any sufficiently advanced technology
is indistinguishable from magic."
........Arthur C. Clarke