Show Random image - Invalid argument error

Hi aquaman,

I think the error you were getting was because some of your variable names didn't match up.

Does this work for you?

<?php // Display random image from selected category in table "header_images_small"
list($header_images_smallRecords, $header_images_smallMetaData) = getRecords(array(
'tableName' => 'header_images_small',
'where' => "category ='{$blogRecord['static_image_random']}'", //Gets the category id chosen in "blog"
'orderBy' => 'RAND()',
'limit' => 1,
'allowSearch' => '0',
));
$header_images_smallRecord = $header_images_smallRecords[0]; // get first record
?>

<div class="feature">
<?php shuffle($header_images_smallRecord['image']) ?>
<?php foreach ($header_images_smallRecord['image'] as $upload): ?>
<?php if ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="<?php echo $header_images_smallRecord['title'] ?>" />
<?php endif ?>
<?php break ?>
<?php endforeach ?>
</div>

I hope this helps. Please let me know if you have any questions.

Hi Chris, I'm getting these errors now, see http://staging.naia.com.fj/post.php?coral-3

Notice: Undefined offset: 0 in /home/naia/www/staging.naia.com.fj/post.php on line 81
Warning: shuffle() expects parameter 1 to be array, null given in /home/naia/www/staging.naia.com.fj/post.php on line 85
Warning: Invalid argument supplied for foreach() in /home/naia/www/staging.naia.com.fj/post.php on line 86

Have attached the full page below. Look for the section:
<?php elseif ($blogRecord['header_type'] == 'random'): ?>

A few notes:

The random images are being pulled from a table called:
header_images_small which has the following fields: title, image, category. The field "category" is setup to pull the values from a different table - see attached image of setup.

Many thanks for your help!!
Jan

Hi aquaman,

Please change this:

$header_images_smallRecord = $header_images_smallRecords[0]; // get first record

to this:

$header_images_smallRecord = @$header_images_smallRecords[0]; // get first record
if (!$header_images_smallRecord) { print "Could not find a header_images_small record for category = '{$blogRecord['static_image_random']}'"; exit; }

Hopefully that will give us more information about the problem. Are you sure there are records for that category?

Please let me know what you discover.

Hi Chris, Thanks so much for persisting with this...

I have added that code and it spits out this:

Could not find a header_images_small record for category = '1'

I checked in phpmyadmin to be sure there are a bunch of images with category set to 1 (see attached)

Hi aquaman,

Ahh, I can see from your screenshot that your category field is a "multi-value" list field. To check if a value is in a multi-value list field, you'll need to use a LIKE test:

'where' => "category LIKE '%\t{$blogRecord['static_image_random']}\t%'", //Gets the category id chosen in "blog"

I hope this helps. Please let me know if you have any questions.

Fantastic, That worked!

Thanks so much for your outstanding help & support.

cheers
Jan