List most recent uploads

Hi, All -

I can confirm that this does work. However, on it's own, it isn't ideal as it relies to heavily on "info1" data for identification purposes. I think it would be much more useful if you were to combine this code with the code Dave put together in answer to my random images post...

Forum Link

In this instance, the code not only pulls out the image but also the record that goes with it. In this way you can identify the image with the record name/title as well as providing a link straight back to the record.

I've tried to adapt Dave's code to work with Jake's code (above).


<?php

require_once "/xyz/viewer_functions.php";

list($uploadRecords, $uploadMetaData) = getRecords(array(
'tableName' => 'uploads',
'where' => 'tableName = "catalogue" && fieldName = "images"',
'orderBy' => 'createdTime DESC',
'limit' => '5',
));
$upload = @$uploadRecords[0];

// get first record
// load record
$recordNum = @$upload['recordNum'];
list($productRecords, $productMetaData) = getRecords(array(
'tableName' => 'catalogue',
'where' => "num = '$recordNum'",
'limit' => '5',
));
$product = @$productRecords[0];
// get first record

?>

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

<a href="<?php echo $product['_link'] ?>"><IMG SRC="<?php echo $record['thumbUrlPath'] ?>" /> <BR /> <?php echo $product['title'] ?></a>

<?php endforeach ?>





The foreach code above is meant to display the thumbnail of the image with the title of the corresponding record underneath. Both the thumb and the the title act as a link back to the record.

Unfortunately, although it does indeed display the thumbs of the 5 most recently uploaded images, the link and title data is only correct in the first instance. The same data is repeated for each of the 4 remaining thumbs.

Is there anyway to fix this?

:0)

Perch