Possible to have a multi record section feed into another multi record section?

Greg, awesome thanks. I'll put together an email to send.

So I have the functionality working and wanted to post some of it here to see if there are better ways to do this.

To review I have the following sections:

- Properties
this section contains all the details about each new property. The customer manually enters the name)

- Pricing Seasons
this section has fields for Season name, season value (all lowercase no spaces to store in the DB), and the date range that season covers.

- Property Pricing
this section pulls in the list of Propert names from the Properties section and the list of Seasons from the Seasons seciton. We can then add a new entry for each pricing property/season combo

I then have the following DB calls at the top:

// load record from 'property_listings'
list($property_listingsRecords, $property_listingsMetaData) = getRecords(array(
'tableName' => 'property_listings',
'where' => " TRIM(property_name) LIKE '".mysql_escape($title_like)."'",
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$property_listingsRecord = @$property_listingsRecords[0]; // get first record
if (!$property_listingsRecord) { dieWith404("Record not found!"); } // show error message if no record found

// load records from 'pricing_seasons'
list($pricing_seasonsRecords, $pricing_seasonsMetaData) = getRecords(array(
'tableName' => 'pricing_seasons',
'loadUploads' => false,
'allowSearch' => false,
'orderBy' => 'dragSortOrder',
));

To display details on the property I use all the variables from $property_listingsRecord.

Now, to show the pricing details I do the following. Let me know if there is a better method:

<?php foreach ($pricing_seasonsRecords as $pricing_seasonsRecord): ?>

<?php
$priceRecords = mysql_query_fetch_all_assoc("SELECT price,pricing_note FROM {$TABLE_PREFIX}property_pricing WHERE season='$pricing_seasonsRecord[value]' AND property='$property_listingsRecord[num]' ORDER BY dragSortOrder DESC");
?>

<?php if ($priceRecords): ?>

<?php foreach ($priceRecords as $priceRecord): ?>

<?php echo htmlencode($pricing_seasonsRecord['title']) ?>
<br />
<?php if ($priceRecord['pricing_note']) { echo "<span style='font-size: 10px;'>".$priceRecord['pricing_note']."</span>"; } ?>

<?php echo money_format('$%i', $priceRecord['price']) ?>

<?php echo $pricing_seasonsRecord['dates'];?>

<?php endforeach ?>
<?php endif ?>
<?php endforeach ?>

I also need to grab the overall minimum and maximum price for each property. To do this, at the top I'm including these:

$minPrice = mysql_query_fetch_all_assoc("SELECT price FROM {$TABLE_PREFIX}property_pricing WHERE property='$property_listingsRecord[num]' ORDER BY price ASC");
$maxPrice = mysql_query_fetch_all_assoc("SELECT price FROM {$TABLE_PREFIX}property_pricing WHERE property='$property_listingsRecord[num]' ORDER BY price DESC");

Not sure if this is the best method or not.

I would like to say thank you again for helping. This is awesome....and is making this project be that much better.

-Kevin