It worked.  Thank you.

Ragi

'where'       => "num = '".mysql_escape(@$_REQUEST['title'])."'",

Please let me know if that works.

Thanks!

Attached are all 3 files.

Ragi

Can you post your getRecords code from historyAwards.php file?

Have you tried 'where' => @$_REQUEST['award'], getRecords parameter?

You can try it on my sandbox at http://742sandbox.northernpenguin.com/history.php

Ragi

Can you confirm if I understand your question correctly:
The "Select an award" select field options in the second form displays the records from $historical_notesRecords and not from $awards_trophiesRecords?

In that case, to troubleshoot, I would check first if the two records contain the data that I'm expecting by displaying them, ie:

// add this below your getRecords function calls
showme($historical_notesRecords);
showme($awards_trophiesRecords);

If everything looks good, I will then construct the select fields for both records: no form tags, no submit button, just the select fields.

If both select fields display the records that you're expecting, add them to a form, then add them to their own form(the two forms you have), and so on.

With this process, we'll be able to pinpoint when/where/why the second select field is displaying records from the first one.
Please let me know what you've found.

Thanks,

I have created a web page that has two (for now) forms, each connected to different multi-record table.  The problem is, no matter what I do, the second form always displays the top record and nothing else.

This is the top code:

<?php include 'common/includes/php_header.inc'; ?>
<?php
  // load record from 'history_overview'
  list($history_overviewRecords, $history_overviewMetaData) = getRecords(array(
    'tableName'   => 'history_overview',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $history_overviewRecord = @$history_overviewRecords[0]; // get first record
  if (!$history_overviewRecord) { dieWith404("Record not found!"); } // show error message if no record found


  // load list records from 'historical_notes'
  list($historical_notesRecords, $historical_notesMetaData) = getRecords(array(
    'tableName'   => 'historical_notes',
    'loadUploads' => true,
    'allowSearch' => false,
  ));

  // load records from 'awards_trophies'
  list($awards_trophiesRecords, $awards_trophiesMetaData) = getRecords(array(
    'tableName'   => 'awards_trophies',
    'loadUploads' => true,
    'allowSearch' => false,
  ));
?>

These are the 2 forms:

<table>
<tr>
<td>
  <form method="get" action="historyNotes.php?">
  <h2>Select a year in history:</h2>
    <select name="year">
      <option value="">--</option>
      <?php foreach ($historical_notesRecords as $listRecord): ?>
        <option value="<?php echo htmlencode($listRecord['num']); ?>" <?php selectedIf($listRecord['num'], @$_REQUEST['year']); ?>>
          <?php echo htmlencode($listRecord['title']); ?>
        </option>
      <?php endforeach; ?>
    </select>
    <br>
    <input type="submit" value="Submit">
    </form>
</td>
<td>
<form method="get" action="historyAwards.php?">
  <h2>Select an award:</h2>
    <select name="title">
      <option value="">--</option>
      <?php foreach ($awards_trophiesRecords as $awardRecord): ?>
        <option value="<?php echo htmlencode($awardRecord['num']); ?>" <?php selectedIf($awardRecord['num'], @$_REQUEST['award']); ?>>
          <?php echo htmlencode($awardRecord['title']); ?>
        </option>
      <?php endforeach; ?>
    </select>
    <br>
    <input type="submit" value="Submit">
</form>
</td>
</tr>

</table>


Any ideas would be greatly appreciated!

Ragi