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. \[code\]$query = "SELECT *". ($randomise ? ', RAND() AS ordering' : ''). ' FROM #__banner'. ' WHERE ' . implode( ' AND ', $wheres ). ' ORDER BY sticky DESC, ordering ';\[/code\]
Joomla Banner Ads displaying duplicates
- Thread starter seamon
- Start date