Joomla Banner Ads displaying duplicates

Question

Has anyone used the Joomla banner Ads know how to make the Ads Rand() and DISTINCT. Everything I've tried to change on the banner.php page is not working. Here is what the code looks like. The images will Rand() just fine but they show up in duplicates.

$query = "SELECT *"
. ($randomise ? ', RAND() AS ordering' : '')
. ' FROM #__banner'
. ' WHERE ' . implode( ' AND ', $wheres )
. ' ORDER BY sticky DESC, ordering ';

Answer 1

Are you setting $randomise, otherwise 'ordering' won't be set. Also, you are specifying two order clauses, so both will be taken into account. I'm not sure what sticky menas, but you could just go: ORDER BY RAND()

$query = "SELECT * FROM #__banner WHERE " . implode( ' AND ', $wheres ) . " ORDER BY RAND()";