Detail page display

Hi,

I would need to actually see your code to be sure, but I think what's happening is the record your supplying for "Current Exhibition" is being selected based on the record number in the url. On the example you gave that isn't working, the last number in the URL is 2. If there isn't an exhibition record with the number 2, then it would be an empty record that your passing into your foreachloop.

You would probably want to change how you're selecting your exhibitions. Perhaps just selecting the most recent record.

Hope this helps.

Please post the complete PHP source code for your fundraising_black_swan_arts_Detail.php page. :)

Also forgot to add that the exhibitions (current, forthcoming, previous) are displayed using a list option and then a where clause in the php. Not sure if that makes a difference? Thanks!

Hi,

I think the problem you're having is in this code here:
// load records
list($current_exhibition_thumbRecords, $current_exhibition_thumbMetaData) = getRecords(array(
'tableName' => 'current_exhibition_thumb',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$current_exhibition_thumbRecord = @$current_exhibition_thumbRecords[0]; // get first record

You're selecting an exhibition record based on a record number in the url string. However, the record number in your string is referring to a fund raising record. If the fund raising record number in the url string doesn't match a record in the exhibition table, then the variable $current_exhibition will have no value. Since you're using the "@" symbol, you're suppressing the error message.

You'll need to use a different criteria to select your exhibition record. You could try something like this:
// load records
list($current_exhibition_thumbRecords, $current_exhibition_thumbMetaData) = getRecords(array(
'tableName' => 'current_exhibition_thumb',
'allowSearch' => false,
'limit' => '1',
));
$current_exhibition_thumbRecord = @$current_exhibition_thumbRecords[0]; // get first record

This will just select the first record in your exhibition list (probably the last one added)

Hope this helps.