Automatically add users name

Hi Chris,

I just tried to implement the code above and I’m getting strange results.

Near as I can tell, the bottom record in the record list does not show up on the list page, but 2 identical entries show up for the next to last record.

In this example I created a total of 6 records.

Here's the link to the list page:

http://artistsofpalmbeachcounty.org/eblast2.php

As you can see there are 6 records, but the last 2 are duplicates and the real last record (test3) does not show at all.

I have no idea why this is happening, but I’ll bet you do.

Best,

Jerry Kornbluth

Here’s the code at the top of my page. The table is called e_blast.

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

require_once "/mypathto/cmsAdmin/lib/viewer_functions.php";

list($e_blastRecords, $e_blastMetaData) = getRecords(array(
'tableName' => 'e_blast',
));
// collect a list of all createdByUserNum in this record set
function collectCreatedByUserNum($record) { return $record['createdByUserNum']; }
$accountNums = array_unique(array_map('collectCreatedByUserNum', $e_blastRecords));
// fetch only the account records we need
list($accountsRecords, $accountsMetaData) = getRecords(array(
'tableName' => 'accounts',
'where' => "num IN (" . join(",", $accountNums) . ")"
));
// index account records by num
function collectNum($record) { return $record['num']; }
$accountsRecordsByNum = array_combine(array_map('collectNum', $accountsRecords), $accountsRecords);
// add 'createdByUserNumAccount' key to records which links to account record
foreach ( array_keys($e_blastRecords) as $key ) {
$record =& $e_blastRecords[$key];
$record['createdByUserNumAccount'] = $accountsRecordsByNum[$record['createdByUserNum']];
}

?>

and the code that I’m using in the body:

<?php foreach ($e_blastRecords as $record): ?>

<a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a><br/>
Author: <span class="body-text-bold-italic"> <?php echo $record['createdByUserNumAccount']['fullname'] ?></span><br />
<?php echo $record['type'] ?><br/>
<?php echo date("M jS, Y", strtotime($record['date'])) ?><br/>



<hr color="EFEFEF" width="200" align="center"/>
<?php endforeach; ?>