Hi,
I try to select from table "used_items" records where specified upload field "photos" are exist.
list($uirandomRecords, $uirandomMetaData) = getRecords(array(
'tableName' => 'used_items',
'orderBy' => "RAND()",
'where' => 'xxx'
'limit' => '5',
'loadUploads' => '1',
'allowSearch' => '0',
'debugSql' => true,
));
showme($uirandomRecords);
how can i request in the 'where' that only select records which have upload images in the photos field?
Any suggestion would appreciated.