random select records where upload field are true

Hi,

In CMS Builder, all uploads are actually stored in a separate table called "uploads". The best solution here would be to first query the uploads table to find out which records in your "used_items" table have uploads. We can then use that list to randomly order those records.

Try this:

$imageQuery = "SELECT * FROM `{$TABLE_PREFIX}uploads` WHERE tableName = 'used_items' AND fieldName='photos' GROUP BY recordNum";
$imageRecords = mysql_query_fetch_all_assoc($imageQuery);

$recordNumList = join(",",array_pluck($imageRecords,'recordNum'));

if(!$recordNumList){$recordNumList=0;}

list($uirandomRecords, $uirandomMetaData) = getRecords(array(
'tableName' => 'used_items',
'orderBy' => "RAND()",
'where' => "num IN ($recordNumList)",
'limit' => '5',
'loadUploads' => '1',
'allowSearch' => '0',
'debugSql' => true,
));

Hope this helps

Hi Jason,

Thank you!
Your solution worked perfectly.