'Where' to find an answer!

Perch, here's the code in modern format. Note that I don't have all your sections setup locally so this is untested.

// load upload
list($uploadRecords, $uploadMetaData) = getRecords(array(
'tableName' => 'uploads',
'where' => 'tableName = "products_classic" && fieldName = "images"',
'orderBy' => 'RAND()',
'limit' => '1',
));
$upload = @$uploadRecords[0]; // get first record

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

Let me know how it goes! :)

Hi, Dave (and Jake) -

Thanks for your help with this matter. I've used both versions of the code to create random image pages - and both work very well.

However, there is one small issue which is rather interesting...

The code works by pulling images from the Uploads table. Trouble is, this includes images which belong to records that have been deleted! I checked the Upload table via phpmyadmin and, sure enough, all the images I've uploaded are still present.

As a work around I've added some more code to the Uploads' "where" condition - which seems to do the trick.

It's not really an issue but it is interesting to learn that the Uploads stay around even when the records associated with them have been erased!

Thanks, again, for your help.

:0)

Perch

Hi perch,

Thanks for reporting that. Uploads should be erased with records in all cases. I'll do some tests on that locally and fix it for the next version if needed.

I have this:

<?php

require_once "/home/content/d/e/r/derekseal/html/utahreoexperts/cmsAdmin/lib/viewer_functions.php";

// load upload
list($uploadRecords, $uploadMetaData) = getRecords(array(
'tableName' => 'uploads',
'where' => 'tableName = "videos" && fieldName = "video"',
'orderBy' => 'RAND()',
'limit' => '1',
));
$upload = @$uploadRecords[0]; // get first record

// load record
$recordNum = @$upload['recordNum'];
list($videosRecords, $videosMetaData) = getRecords(array(
'tableName' => 'videos',
'where' => "num = '$recordNum'",
'limit' => '1',
));
$videos = @$videosRecords[0]; // get first record

?>

And then I put variables to list as:

<?php echo $videosRecord['title'] ?>
<?php echo $videosRecord['description'] ?>

But it seems to take me the uploads but no the videosRecord, as you can see in:

http://www.utahreoexperts.com/selling-your-home/videos-about-selling-a-home/video/?Video-1-Selling.-3

Please help with this one.

Cheers, Juan.

Hi Juan,

A quick question first - what version of CMS Builder are you running?

Try this:

<?php echo $videos['title'] ?>
<?php echo $videos['description'] ?>

Let me know if that fixes it.