[небольшой хак] Случайные объявления - AdsManager

<div class="info">
<h3><?php echo ADSMANAGER_INFO; ?></h3>
<?php
$database->setQuery( "SELECT * FROM #__adsmanager_ads WHERE 'id'!='$row->id' ORDER BY RAND() LIMIT 5");
$infos = $database->loadObjectList();
foreach($infos as $info){
echo '<div class="inform">';
echo '— <a href="index.php?option=com_adsmanager&amp;page=show_ad&amp;adid='.$info->id.'">'.$info->ad_headline.'</a><br />';
echo '</div>';
}
?>
</div>

<div class="info">
<h3><?php echo ADSMANAGER_INFO; ?></h3>
<?php
$database->setQuery( "SELECT c.*, a.* FROM #__adsmanager_ads a join #__adsmanager_adcat c on a.id=c.adid WHERE (a.id!='$row->id') and (c.catid = '$catid') ORDER BY RAND() LIMIT 5");
$infos = $database->loadObjectList();
foreach($infos as $info){
echo '<div class="inform">';
echo '— <a href="index.php?option=com_adsmanager&amp;page=show_ad&amp;adid='.$info->id.'&amp;catid='.$catid.'">'.$info->ad_headline.'</a><br />';
echo '</div>';
}
?>
</div>

<div class="info">
<h3><?php echo ADSMANAGER_INFO; ?></h3>
<?php
 global $mosConfig_live_site,$mosConfig_absolute_path,$my,$database;

$database->setQuery( "SELECT c.*, a.* FROM #__adsmanager_ads a join #__adsmanager_categories c on a.category=c.id WHERE (a.id!='$row->id') and (c.id='$row->category') ORDER BY RAND() LIMIT 3");
$infos = $database->loadObjectList();


foreach($infos as $info){
echo '<div class="inform">';
//Обработка вывода цены
$nums = $info->ad_price;
$format_ad_price = number_format($nums,' ');
//
echo '— <a href="index.php?option=com_adsmanager&amp;page=show_ad&amp;adid='.$info->id.'&amp;catid='.$info->category.'">'.$info->ad_headline.'</a>&nbsp;&nbsp;'.$format_ad_price.''. ADSMANAGER_DEVICE. '<br />';
echo '</div>';
}

?>
</div>

$format_ad_price = number_format($nums,' ');

$format_ad_price = number_format($nums,0, ',', ' ');

$format_ad_price = number_format($nums,0, ',', ' ');

"SELECT a.id,a.views, a.ad_headline, a.category, a.date_created,p.id as parentid,p.name as parent,c.id as catid, c.name as cat, a.ad_price as price ".
					"FROM #__adsmanager_ads as a ".
					"LEFT JOIN #__adsmanager_adcat as adcat ON adcat.adid = a.id ".
					"LEFT JOIN #__users as u ON a.userid = u.id ".
					"LEFT JOIN #__adsmanager_categories as c ON adcat.catid = c.id ".
					"LEFT JOIN #__adsmanager_categories as p ON c.parent = p.id ".
					"WHERE $cat_query c.published = 1 and a.published = 1 GROUP BY a.id $order_sql LIMIT 0, $nb_ads");

	<div class="info">
<h3><?php echo ADSMANAGER_INFO; ?></h3>
<?php
 global $mosConfig_live_site,$mosConfig_absolute_path,$my,$database;

      // explode the meta keys on a comma
      $keys = explode( ' ', $row->ad_headline );
      $likes = array();

      $Compteur = 0;
      // assemble any non-blank word(s)
      foreach ($keys as $key) {
         $key = trim( $key );

         if ($key) {
            $likes[] = $key;
         }
      }


     $likes = implode( "%' OR a.ad_keywords LIKE '%", $likes );

$database->setQuery( "SELECT DISTINCT  c.*, a.* FROM #__adsmanager_ads a join #__adsmanager_categories c WHERE (a.id!='$row->id')and (a.ad_keywords LIKE '%.$likes.%')   ORDER BY RAND() LIMIT 3");
$infos = $database->loadObjectList();


foreach($infos as $info){
echo '<div class="inform">';
//Обработка вывода цены
$nums = $info->ad_price;
$format_ad_price = number_format($nums,' ');
//
echo ' <a href="index.php?option=com_adsmanager&amp;page=show_ad&amp;adid='.$info->id.'&amp;catid='.$info->category.'">'.$info->ad_headline.'</a>&nbsp;&nbsp;'.$format_ad_price.''. ADSMANAGER_DEVICE2. '<br />';
echo '</div>';
}

?>
</div>