On this page I have leasing contacts in the right column.
http://173.236.177.72/suite.php?510-514-3
These agents are being pulled from the agent section which are check boxes in the suite section. Even if I select both agents only the first one shows up. This is the code that I have.
Code located at the top of the page:
list($agentsRecords, $agentsMetaData) = getRecords(array(
'tableName' => 'agents',
'where' => mysql_escapef('num = ?', $suitesRecord['agent']),
'limit' => 1,
));
$agentsRecord = $agentsRecords[0];
?>
Code in the page:
<?php foreach ($agentsRecords as $record): ?>
<?php echo $record['name'] ?>
<br />
T: <?php echo $record['phone'] ?> | F: <?php echo $record['fax'] ?> | E: <a href="mailto:<?php echo $record['email'] ?>"><?php echo $record['email'] ?></a>
<?php endforeach ?>
It is working to a degree where it is displaying at least one of the two agents that are selected but we need it to display all the agents that are selected. I'm sure that I am missing something small.