Live Product List Ordering Question

Any[font "Verdana"] ideas?[/#000000]

Hey,

1.
You can use a sql trick to force mysql to sort by number by using an order by like this:
'orderBy' => "CAST(price as DECIMAL(10,2))"
2.
Could you post some more of the code you're using (or a link to the page)? That will let me see what's going on. From what I can see already, the sfbb_cheap_dl_speed link will sort ascending if it's not the current sort.

Hope that helps,
Robin

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>&pound;<?php echo $record['sfbb_cheap_price'] ?></div>
<div id="ispsearch_box" style="width:90px;"><div id="ispsearch_boxhead"><b>Setup</b></div>&pound;<?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 -->

Hey

1. Intercepting the orderBy might help keep things working as is. Something like:
$orderBy = @$_REQUEST['orderBy'];

if($orderBy=="sfbb_cheap_price") {
$orderBy = "CAST(sfbb_cheap_priceas DECIMAL(10,2))"
}

list($isp_listRecords, $isp_listMetaData) = getRecords(array(
'tableName' => 'isp_list',
'perPage' => '15',
'where' => " category LIKE '%Superfast Broadband%' ",
'orderBy' => $orderBy
'loadCreatedBy' => false,
));

2. It looks like "sfbb_cheap_dl_speed" order by link will sort ascending in any case. Since ASC is implied if no ASC/DESC is stated. Did you want it to sort descending on first click?

Hope that helps,
Robin

1. This bit gives me a syntax error (unexpected '}').

if($orderBy=="sfbb_cheap_price") {
$orderBy = "CAST(sfbb_cheap_price as DECIMAL(10,2))"
}


2. Yes I want it to sort ASC on the first click, but without damaging the DESC nature of the other links. That's the problem.

Hey,

1. Ah line two is missing a semi-colon. Sometimes the compiler in my head isn't perfect. =)


2. I don't think you have a problem. The other links will remain DESC no matter what you change the sfbb_cheap_dl_speed link to.

Hope that helps,
Robin

Sorry about the late reply, been dealing with a problematic server upgrade.. anyway.

1. Unfortunately as soon as I add that code in it messes up the general alphabetic list ordering, though I'm not quite sure why. It must somehow overide A-Z ordering just by existing. Any ideas?

Done, thanks Jason.