1. Yes but my list defaults to A-Z order on the title field, so what I want to do is have something like your example but as part of my custom orderby links as mentioned in no.2 of my original post (i.e. I don't want the entire list to default by price ordering - it must be a visitor option by clicking a link). Is that possible?
2. Sure and I'll cut out the non-relevant formatting stuff to keep it down.
<?php
require_once "system/lib/viewer_functions.php";
list($isp_listRecords, $isp_listMetaData) = getRecords(array(
'tableName' => 'isp_list',
'perPage' => '15',
'where' => " category LIKE '%Superfast Broadband%' ",
'loadCreatedBy' => false,
));
?>
<b>ORDER LIST BY:</b> <a href="ISP_List_Superfast_Broadband.php?orderBy=<?php echo (@$_REQUEST['orderBy']!="title")? "title" : "title+DESC" ?>"><b>ISP Name (Alphanumeric)</b></a> | <a href="ISP_List_Superfast_Broadband.php?orderBy=<?php echo (@$_REQUEST['orderBy']!="sfbb_cheap_price")? "sfbb_cheap_price" : "sfbb_cheap_price+DESC" ?>"><b>Price</b></a> | <a href="ISP_List_Superfast_Broadband.php?orderBy=<?php echo (@$_REQUEST['orderBy']!="sfbb_cheap_setup")? "sfbb_cheap_setup" : "sfbb_cheap_setup+DESC" ?>"><b>Setup Fee</b></a> | <a href="ISP_List_Superfast_Broadband.php?orderBy=<?php echo (@$_REQUEST['orderBy']!="sfbb_cheap_dl_speed")? "sfbb_cheap_dl_speed" : "sfbb_cheap_dl_speed+ASC" ?>"><b>Download Speed</b></a>
<!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
<?php foreach ($isp_listRecords as $record): ?>
<div id="ispsearch_title" style="float:left;"><a href="ISP_Detail_Superfast_Broadband.php?<?php echo preg_replace("/[ ]/", "-", $record['title']); ?>-<?php echo $record['num'] ?>" class="italhead"><b><?php echo $record['title'] ?></b></a></div>
<div style="float:right;padding-top:18px;margin-right:11px;"></div>
<div id="ispsearch_separate" style="clear:both;"></div>
<div id="ispsearch_box" style="width:125px;margin-left:10px;"><div id="ispsearch_boxhead"><b>Package Type</b></div>Cheapest <a href="
http:/ISP_List_Fixed_Line_Broadband.php#info" title="The cheapest price package excludes special offer discounts that apply for less than 6 months">*</a></div>
<div id="ispsearch_box" style="width:90px;"><div id="ispsearch_boxhead"><b>Price</b></div>£<?php echo $record['sfbb_cheap_price'] ?></div>
<div id="ispsearch_box" style="width:90px;"><div id="ispsearch_boxhead"><b>Setup</b></div>£<?php echo $record['sfbb_cheap_setup'] ?></div>
<div id="ispsearch_box" style="width:90px;"><div id="ispsearch_boxhead"><b>Speed (DL)</b></div><?php echo $record['sfbb_cheap_dl_speed'] ?></div>
<div id="ispsearch_box" style="width:90px;"><div id="ispsearch_boxhead"><b>Speed (UL)</b></div><?php echo $record['sfbb_cheap_up_speed'] ?></div>
<div id="ispsearch_box" style="width:195px;"><div id="ispsearch_boxhead"><b>Monthly Data Usage</b></div><?php echo $record['sfbb_cheap_peak'] ?></div>
<div id="ispsearch_box" style="width:90px;"><div id="ispsearch_boxhead"><b>Hardware</b></div><?php echo $record['sfbb_cheap_hardware'] ?></div>
<div id="ispsearch_box" style="width:81px;"><div id="ispsearch_boxhead"><b>Contract</b></div><?php echo $record['sfbb_cheap_contract'] ?></div>
<div style="clear:both;"></div>
<div id="ispsearch_separate"></div>
<br />
<?php endforeach ?>
<?php if (!$isp_listRecords): ?>
<br /><br /><b><u>No records were found!</u></b><br/><br/>
<?php endif ?>
<!-- /STEP2: Display Records -->