Option Where with Uploads on RAND()
2 posts by 1 authors in: Forums > CMS Builder
Last Post: April 26, 2009 (RSS)
By Djulia - April 26, 2009
Hi,
I use a [font "Times New Roman"]Viewer with RAND() and that functions perfectly.
list($tableRecords, $tableMetaData) = getRecords(array(
'tableName' => 'table',
'limit' => '2',
'orderBy' => 'RAND()',
But, I would like that RAND() uses only the records which have images in the table.
I sought a solution with the option Where, but without success :
'where' => 'Uploads = true',
Does somebody have a suggestion ?
Thanks for your assistance.
Djulia
I use a [font "Times New Roman"]Viewer with RAND() and that functions perfectly.
list($tableRecords, $tableMetaData) = getRecords(array(
'tableName' => 'table',
'limit' => '2',
'orderBy' => 'RAND()',
But, I would like that RAND() uses only the records which have images in the table.
I sought a solution with the option Where, but without success :
'where' => 'Uploads = true',
Does somebody have a suggestion ?
Thanks for your assistance.
Djulia