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.

Ahh, I see. My mistake. Try this:

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

or

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

Success [tongue]

Great, glad to hear you got it working.

Let us know if you need anything else. :)