Restrict records shown to those in a specific group

Hi All,

On a site I’m building, I’m trying to restrict the records shown on a list page to only those that belong to a specific group, and I’m almost there (I think).

I’m attempting to do this with the code Dave suggested at the end of http://www.interactivetools.com/iforum/gforum.cgi?post=64168 in answer to Saginetic's query.

So far, I’ve created 2 multi record editors.

One multi record editor, called “exhibitions” contains a separate record for each exhibition. Each record has a field for a unique exhibition_name and an upload field containing a series of still images of those exhibitions. The exhibitions detail page has a link to the video list page with the exhibitions record number appended .

The other, called “videos” has a separate record for each video with a field for the exhibition_name (which gets it’s value from a radio button list populated from the exhibition_name field of the exhibitions editor) and an upload field containing one of the video taken at that exhibitions.

THE PROBLEM
I’d like that video list page to list only the videos that pertain to that exhibition.

However, using the code below, the correct record number of the exhibition is appended to the video link (record 1 or 2) , but the video list page always show only one video, which is actually the last video record (record 3)

I hope that someone's done this before and can see where I’m going wrong, or can suggest a better approach.

Thanks,

Jerry Kornbluth

Here’s the code for the link on the exhibitions detail page:

<a href='<a href='videos.php?<?php echo $exhibitionsRecord['num'] ?>'>WATCH THE VIDEO FROM THIS EXHIBITION</a>

Then in the video list page in the get records area:

// load records
list($exhibitionsRecords, $exhibitionsMetaData) = getRecords(array(
'tableName' => 'exhibitions',
));
$exhibitionsRecord = @$exhibitionsRecords[0]; // get first record
$escapedExhibitionName = mysql_real_escape_string( $exhibitionsRecord['exhibition_name'] );


// load records
list($videosRecords, $videosMetaData) = getRecords(array(
'tableName' => 'videos',
'allowSearch' => false,
'where' => " exhibition_name = '$escapedExhibitionName' ",
));

And in the body of the videos list page a straightforward:
<table>
<?php foreach ($videosRecords as $record): ?>
<tr>
<td>
<?php foreach ($record['list_image'] as $upload): ?>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath2'] ?>" width="<?php echo $upload['thumbWidth2'] ?>" height="<?php echo $upload['thumbHeight2'] ?>" alt="" /></a>
<?php endforeach; ?>
</td>
<td><a href="<?php echo $record['_link'] ?>"><?php echo $record['video_title'] ?></a><br/></td>
</tr>
<tr>
<td colspan="2">
<?PHP echo maxWords($record['description'], 25);
?>...<a href="<?php echo $record['_link']; ?>">Read More...</a></td>
</tr>
<tr>
<td colspan="2"><hr align="center" width="300" color="#99945e"/></td>
</tr>
<?php endforeach; ?>
</table>