Category sidebars

Thanks so much Dave. Your solution worked perfectly. My client can now add content to sidebars that appear on both the category list page and all the articles within that category. PLUS she can write separate sidebars based on the category.

Here's the solution in a nutshell:
1. Admin > Section Editor > Create a section with your categories (Section Name: Cat A, Cat B). I named this section "Admissions" with Undergraduate and Graduate as my categories.
2. Admin > Section Editor > Create another section for your sidebars Add a field for [content] and a list field containing the categories listed above (Cat A, Cat B). I named my section editor "Admissions Resource List" and included a list field containing "Undergraduate" and "Graduate" as options.

Now my client can now create sidebars in the "Admissions Resource List" section and choose which category she'd like that sidebar to appear. The sidebar appears on both the category (List) page and the article pages.

Here's the code for the admissionList.php page. I put it in a right sidebar div tag (well, actually Dave did... thank you Dave):

<!-- STEP1: Load Record List (Paste this above other steps) -->
<?php
require_once "/usr/www/uga/htdocs/dev/cmsAdmin/lib/viewer_functions.php";
$options = array();
$options['tableName'] = 'your_section_name;
$escapedCategory = mysql_real_escape_string(@$_REQUEST['category']);
$options['where'] = "category = '$escapedCategory'";

$record = getRecord($options);
?>
<!-- /STEP1: Load Record List inside sidebar DIV tag -->

<?php echo $record['content'] ?>

Here's the code for admissionsPage.php (article pages). Instead of $_REQUEST['category'] use $record['category'] (or whatever variable holds the category name) instead. Like this:

$escapedCategory = mysql_real_escape_string(@$record['category']);
$options['where'] = "category = '$escapedCategory'"; :

<!-- STEP1 for article pages: Load Record List (Paste this above other steps) -->
<?php
require_once "/usr/www/uga/htdocs/dev/cmsAdmin/lib/viewer_functions.php";
$options = array();
$options['tableName'] = 'your_section_name';

$escapedCategory = mysql_real_escape_string(@$record['category']);
$options['where'] = "category = '$escapedCategory'";

$record = getRecord($options);
?>
<!-- /STEP1: Load Record List inside article page sidebar DIV -->

<?php echo $record['content'] ?><br/>


Worked like a charm!

Thanks again Dave,

Jan