Combining more than 1 multi-record in a single page?

I ended up keeping these as single pages, but am having a similar problem combining a single record field on a multi-record detail page.

'announcements' is the multi record
about is a single record
here's my top code:

============
<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php


// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/webadmin/www/atiintheusa/html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records
list($aboutRecords, $aboutMetaData) = getRecords(array(
'tableName' => 'about',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$aboutRecord = @$aboutRecords[0]; // get first record

// load records
list($announcementsRecords, $announcementsMetaData) = getRecords(array(
'tableName' => 'announcements',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$announcementsRecord = @$announcementsRecords[0]; // get first record

// show error message if no matching record is found
if (!$announcementsRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}

?>
============

Bottom code is working great all of the articles are appearing as they are supposed to. It is the single record that I am having trouble with, as it only appears on the first record, but won't appear on the others...
<h1><?php echo $aboutRecord['announcements_page_title'] ?></h1>

Where am I going wrong? Here's the remaining code:

====================


<h1><?php echo $aboutRecord['announcements_page_title'] ?></h1>
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
<h2 style="padding-top:15px;padding-bottom:7px;"><?php echo $announcementsRecord['title'] ?></h2>
<h3><?php echo $announcementsRecord['content'] ?>
<?php if ($announcementsRecord['date']): ?>
<p class="postdate">posted <?php echo date("F d, Y", strtotime($announcementsRecord['date'])) ?></p>
<?php endif ?></h3>
</td>
</tr>
</table>

Hey,

If about is a single record, just remove the 'where' line in the load records and it will always show.

Hope that works for you,
Robin

Thank you. I thought I did that, but it was still showing... Working great now though!

Back to the original multiple multi records...

So if my detail page is a template, being used by multiple records, do I have to create this line several times?

For instance, the main multi-record page would be
=========================
// load records
list($water_care_productsRecords, $water_care_productsMetaData) = getRecords(array(
'tableName' => 'water_care_products',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$water_care_productsRecord = @$water_care_productsRecords[0]; // get first record

===================================

So if there are 6 products there, they all have different tables, I assume. And then they each have a different set of multi records to include the specs. These are:

===================================


// load records
list($coral_ocean_specificationsRecords, $coral_ocean_specificationsMetaData) = getRecords(array(
'tableName' => 'coral_ocean_specifications',
));

-=================================

I was told it was possible to include the specifications table within the original multi-listing page and I posted a separate post to the forum about this, as it may be better, but either solution would be fine if I could get it to work.

Hey,

I'm not quite sure what you're asking? Do you want to display all your products on one page or just show one of many possible products?

Thanks,
Robin

I have a multi-record element for products.
Here, I create a detail page for each product.

Then I have a multi-record element for each product specifications.
This creates a list (in table format) for specifications of a particular product.

I'd like to have the product detail page include the specifications for the appropriate product, but since the product detail page is a template, I am not sure how to appropriately do that.

Alternatively, I'd LOVE to include the specifications table within the product information, but since this is a list of specifications that contain anywhere from 2-20 rows of information, I'm not quite sure how to do this.

To reference what a page looks like (the code is single record at the moment) check out http://www.atiintheusa.com/bulbs.php

if you click on the "Specifications" tab that is below the product image and intro, you will see the multi-record table for that product...