Sorting by Category Field in Different Template Files

Hi mark99,

>I have several different product types under one section. I do
>this because to create a new section for each category of
>product would cause too much repetition

This is a great way to set it up and exactly as we would recommend.

I'm not totally clear on what you're trying to do so I'm going to make a few guesses. If none of those are a match please post more details or examples urls is possible.

Here's a mix of simple to more advanced ways to do it:

To have a list page only show records matching a certain category you can specify that in the url:
list.php?category=parts

or specify it in the where options:
'where' = " category = 'parts' ",

or put it in a variable at the top of the page:
$thisCategory = 'parts';
...
'where' = " category = '$thisCategory' ",

or detect it based on the filename
$thisCategory = 'default';
if (strstr($_SERVER['SCRIPT_NAME'], 'parts.php')) { $thisCategory = 'parts'; }


Then, if you want to show a different style of page based on the selected category you can have your list page include an other more designed page:

if ($thisCategory == 'parts') { include "list_parts.php"; exit; }
if ($thisCategory == 'widgets') { include "list_widgets.php"; exit; }

Or you could load different headers based on the category:

if ($thisCategory == 'parts') { include "header_parts.php"; }
if ($thisCategory == 'widgets') { include "header_widgets.php"; }

Or just show different HTML:

if ($thisCategory == 'parts') { print "<h1>Parts</h1>"; }
if ($thisCategory == 'widgets') { print "<h1>Widgets</h1>"; }

If there's certain fields you only want displayed if they are not blank you can test to see if they have a value:

<?php if ($record['manufacturer']): ?>
Manufacturer: <?php echo $record['manufacturer'] ?>
<?php endif ?>

And if you wanted to sort the records differently based on category, you could do that like this:

$orderBy = 'price'; // default sorting
if ($thisCategory == 'parts') { $orderBy = 'size DESC'; }
if ($thisCategory == 'widgets') { $orderBy = 'price'; }
...
'orderBy' => $orderBy,


I hope some of that made sense - and was helpful!

Let me know, if not we'll keep trying! :)

I tried this (the where call) but had no luck, it just returned no records even though there are:

<?php

require_once "viewer_functions.php";
$thisCategory = 'dogs with tails';
list($isp_listRecords, $isp_listMetaData) = getRecords(array(
'tableName' => 'isp_list',
'limit' => '5',
'where' => " category = '$thisCategory' ",
));
?>

"category" is a field in my new section and 'dogs with tails' is one of the category options. So I just want my Viewer.php to output reports that have 'dog' as a category and then I can make a customer .php viewer template file for each category to keep it simple. I think the problem is probably with the syntax you gave me for the 'where' line but I'm not sure, PHP is not my stong point :) .

Hi mark99,

Is category a multi-value field? Does it let you select multiple categories?

If so, use this line:
'where' => " category LIKE 'dogs with tails' ",

Otherwise, you can use this debug code _after_ the get records code to temporarily see what the category values are and why they are not matching:

showme( $isp_listRecords );
exit;

Let me know what you find out.

Yes "category" is a multi-value field selected by checkboxes (some products have several categories selected and others just one), my cat/dog stuff is just an example.

I get no output if I use that 'where' call you mention with the debug code, the array is obviously blank. Here's a sample of the returned array without the "where" call.

[1] => Array
(
[num] => 1
[createdDate] => 2009-12-10 14:13:40
[createdByUserNum] => 1
[updatedDate] => 2010-02-25 15:29:46
[updatedByUserNum] => 1
[dragSortOrder] => 1260454420
[title] => Zen Internet
[notes] =>
[website] => http://www.zen.co.uk
[category] => Fixed Line Broadband
[ispa_member] => Yes
[ofcom_adr_scheme] => CISAS
[suppliers] =>
[land_line_broadband_type] => ADSL ADSL2+ Fibre to the Cabinet (FTTC)
[review_id] => 270
[telephone_support] => 08450589000
[land_line_price] => 17.99
[land_line_setup] => 0.00
[land_line_dl_speed] => 20Mbps


Now if I add this..

'where' => " category LIKE 'Fixed Line Broadband' ",

Under this..

'tableName' => 'isp_list',
'limit' => '5',

Then I just get no output.

But I know it works because this works fine:

http://www.site.com/viewer_test.php/category-Fixed_Line_Broadband[/#336699][/url]

Ahh, I see. My mistake. Try this:

'where' => " category LIKE '%Fixed Line Broadband%' ",

or

'where' => " category LIKE '%$thisCategory%' ",

Great, glad to hear you got it working.

Let us know if you need anything else. :)