Creating a list page with information from 2 multi record editors

Hi All,

Stumped again...

I’m trying to create a list page using information from 2 multi record editors. “Exhibitions”, and “Opening Receptions”.

Both editors pull a check box list of event titles from a master events list multi record editor and the specific event title then is checked on each record in the “Exhibitions” and “Opening Receptions” editors.

The event editor has all of the permanent event information and the other has opening reception information only for those events. (I’m using 2 editors so that the “Opening Reception” information can automatically be hidden after the reception date has passed)

I can’t seem to get the “Opening Reception” information to display with the corresponding event. In spite of the “where” code in the head, all of the “Opening Reception” dates show in each event listing.

I’ve tried a number of approaches and am out of ideas.


The link to the page I’m trying to create is: http://www.lkmix.com/index3.php


Thanks,

Jerry Kornbluth

Here’s the code that I’m using in the head:

<?php

require_once "/hsphere/local/home/craftgallery/lkmix.com/cmsAdmin/lib/viewer_functions.php";

list($exhibitionsRecords, $exhibitionsMetaData) = getRecords(array(

'tableName' => 'exhibitions',

));


list($opening_receptionsRecords, $opening_receptionsMetaData) = getRecords(array(

'tableName' => 'opening_receptions',

'where' => "exhibition LIKE '%" .mysql_real_escape_string(@$_REQUEST['sort_exhibition']). "%'",

));


?>

And in the body (without the styling info):

<table>

<?php foreach ($exhibitionsRecords as $record): ?>

<tr>

<td><a href="<?php echo $record['_link'] ?>"><?php echo $record['exhibition'] ?></a>

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

<br />

Show Dates: <?php echo date("D, M jS", strtotime($record['opening_date'])) ?> - <?php echo date("D, M jS, Y ", strtotime($record['closing_date'])) ?><br />

<?php echo $record['days_and_times'] ?></p><hr color="#C70000" width="300" /<br />Opening Reception: <?php foreach ($opening_receptionsRecords as $record): ?><?php echo date("D, M jS", strtotime($record['reception_date'])) ?><?php endforeach; ?></td>

</tr> <?php endforeach; ?>

</table>