Image Rotator Question

Hi All,

I’m using an upload field in my accounts table to hold multiple images. These images are to be used in a single image rotator which  displays a single random image from a random account.

In the displayed image I’m using the filename to display the title of the image (removing the .jpg and other extraneous information with preg_replace).

I’m also displaying the name of the artist from the name fields in the account record.

This first code block, which I cobbled together from another implementation, works, but it since it loops through all of the account record images and then displays one image, I’m concerned about server loads as the number of records and images increases. I'm also not sure how to get around the  <?php if (@$alreadySeen[ $record[''] ]++) { continue; } ?> code which I don't think is valid code but seems to work.

<?php  
    list($accountsRecords, $accountsMetaData) = getRecords(array(
    'tableName'   => 'accounts',
    'loadUploads' => true,
    'allowSearch' => false,
     'orderBy'     => 'RAND()',
  ));
  ?>

<table align="center" width="80%" border="0" cellpadding="5">
  <tr>
    <?php foreach ($accountsRecords as $record): ?>
    <?php shuffle($record['images']) ?>
    <?php foreach ($record['images'] as
$upload): ?>
    <?PHP $upload['filename'] = preg_replace('/\.\w+$/', '', $upload['filename']); ?>
    <?PHP $upload['filename'] = preg_replace("/[-_]/", " ", $upload['filename'] ); ?>
    <?PHP $upload['filename'] = ucwords($upload['filename'] ); ?>
    <?php if (@$alreadySeen[ $record[''] ]++) { continue; } ?>
    <td align="center"><div onclick='window.location="<?php echo $record['url'] ?>"' class="round-corner" style="position: relative; background: url(<?php echo
$upload['thumbUrlPath2'] ?>); width: <?php echo $upload['thumbWidth2'] ?>px; height: <?php echo $upload['thumbHeight2']
?>px;">
        <div style="position: absolute; top: .9em; left: 1.2em; width: 200px; font-family:Verdana, Tahoma, Arial, Sans-Serif;
font-size:1.2em; font-weight:bold; text-align:left; font-style: normal; color: #00F;" class="shadow1"><?php echo $upload['filename']
?></div>
        <div style="position: absolute; bottom: 1.2em; left: 1.2em; width: 200px; font-family:Verdana, Tahoma, Arial, Sans-Serif;
font-size:1.2em; font-weight:bold; text-align:left; font-style: normal; color: #00F;" class="shadow1"><?php echo $record['first_name']
?> <?php echo $record['last_name']
?></div>
      </div></td>
    <?php endforeach ?>
    <?php endforeach ?>
  </tr>
</table>


In this second block, I’m using a mysql_select to limit the loaded records to those that contain images.

<?php $uploadRecords = mysql_select('uploads', " tableName = 'accounts' AND fieldName = 'images'"); ?>

<table align="center" width="80%" border="0" cellpadding="5">
  <tr>
    <?php shuffle($uploadRecords) ?>
    <?php foreach ($uploadRecords as
$upload): ?>
    <td align="center"><div onclick='window.location="#"' class="round-corner" style="position: relative; background: url(<?php echo $masterurl ?>/cmsAdmin/uploads/<?php echo
$upload['thumbUrlPath2'] ?>); width: <?php echo $upload['thumbWidth2'] ?>px; height: <?php echo $upload['thumbHeight2']
?>px;">
        <?PHP $upload['urlPath'] = preg_replace('/\.\w+$/', '', $upload['urlPath']); ?>
        <?PHP $upload['urlPath'] = preg_replace("/[-_]/", " ", $upload['urlPath'] ); ?>
        <?PHP $upload['urlPath'] = ucwords($upload['urlPath'] ); ?>
        <div style="position: absolute; top: .9em; left: 1.2em; width: 200px; font-family:Verdana, Tahoma, Arial, Sans-Serif;
font-size:1.2em; font-weight:bold; text-align:left; font-style: normal; color: #00F;" class="shadow1"><?php echo $upload['urlPath']
?></div>
        <?php  
    list($accountsRecords, $accountsMetaData) = getRecords(array(
    'tableName'   => 'accounts',
    'loadUploads' => true,
    'allowSearch' => false,
    
  ));
  ?>
        <?php foreach ($accountsRecords as $record2): ?>
        <div style="position: absolute; bottom: 1.2em; left: 1.2em; width: 200px; font-family:Verdana, Tahoma, Arial, Sans-Serif;
font-size:1.2em; font-weight:bold; text-align:left; font-style: normal; color: #00F;" class="shadow1">
          <?php  echo $record2['first_name']
?>
          <?php echo $record2['last_name']
?></div>
      </div></td>
    <?php break?>
    <?php endforeach ?>
    <?php break?>
    <?php endforeach ?>
  </tr>
</table>


My Problem is that I’m not sure how to pull the record name fields from the image’s parent record. The existing code currently shows the name of the first record each time.

Any help would be great.

Thanks,

Jerry Kornbluth