Jason: I keep getting "Record not found". Below is my actual code:
// load detail record from 'squadron_news'
list($squadron_newsRecords, $squadron_newsMetaData) = getRecords(array(
'tableName' => 'squadron_news',
'where' => whereRecordNumberInUrl(1), // If no record # is specified then latest record is shown
'loadUploads' => true,
'allowSearch' => true,
'limit' => '1',
));
$detailRecord = @$squadron_newsRecords[0]; // get first record
if (!$detailRecord) { dieWith404("Record not found!"); } // show error message if no record found
// load list records from 'squadron_news'
list($squadron_newsRecords, $squadron_newsMetaData) = getRecords(array(
'tableName' => 'squadron_news',
'loadUploads' => true,
'allowSearch' => true,
));
and the html:
<div id="contentContainer"><!-- Start main content wrapper -->
<div id="content"><!-- Start content -->
<h2>Squadron News</h2>
<b>Record Detail</b><br/>
Record Number: <?php echo htmlencode($detailRecord['num']) ?><br/>
Squadron (value): <?php echo $detailRecord['squadron'] ?><br/>
Squadron (label): <?php echo $detailRecord['squadron:label'] ?><br/>
Title: <?php echo htmlencode($detailRecord['title']) ?><br/>
Content: <?php echo $detailRecord['content']; ?><br/>
</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">
<form name="choose" action="" method="get">
Choose a squadron:
<select name="squadron" size="1" style="width: 160px;">
<option value=""><select a squadron></option>
<?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