'tile_images',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$tile_imagesRecord = @$tile_imagesRecords[0]; // get first record
// show error message if no matching record is found
if (!$tile_imagesRecord) {
print "Record not found!";
exit;
}
// compile a list of tile nums to fetch
$tile_fields = array('floor_tile', 'floor_grout', 'shower_wall');
global $tile_imagesRecord;
function collectRecordValues($field) {
global $tile_imagesRecord;
return $tile_imagesRecord[$field] ? $tile_imagesRecord[$field] : 0;
}
$tile_nums = join(', ', array_map('collectRecordValues', $tile_fields));
// fetch referenced tiles and index by num
list($tileRecords, $tileMetaData) = getRecords(array(
'tableName' => 'tile',
'where' => "num IN ($tile_nums)",
));
function collectNum($record) { return $record['num']; }
$tileRecordsByNum = array_combine(array_map('collectNum', $tileRecords), $tileRecords);
// inject tile records into tile_images record's fields
foreach ( $tile_fields as $field ) {
$tile_imagesRecord[$field] =& $tileRecordsByNum[ $tile_imagesRecord[$field] ];
}
?>
tile_images - Detail Page Viewer
Record Number:
Title:
Floor Tile:
Floor Grout:
Shower Wall:
No record found!