The Joomla! Forum ™

<?php
//Related Content//
/**
* Related Content Module
* @package Joomla
* @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* Joomla! is free software and parts of it may contain or be derived from the
* GNU General Public License or other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/
 
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
 
$option = trim( mosGetParam( $_REQUEST, 'option', null ) );
$task = trim( mosGetParam( $_REQUEST, 'task', null ) );
$id = intval( mosGetParam( $_REQUEST, 'id', null ) );
$itemid = intval(mosGetParam( $_REQUEST,'Itemid',null));

if ($option == 'com_content' && $task == 'view' && $id) {

 // select the meta keywords from the item
 $query = "SELECT metakey FROM #__content WHERE id='$id'";
 $database->setQuery( $query );

 if ($metakey = trim( $database->loadResult() )) {
  // explode the meta keys on a comma
  $keys = explode( ',', $metakey );
  $likes = array();

  // assemble any non-blank word(s)
  foreach ($keys as $key) {
   $key = trim( $key );
   if ($key) {
    $likes[] = $key;
   }
  }
  if (count( $likes )) {
   // select other items based on the metakey field 'like' the keys found
  

   $query = " SELECT id, title"
           . " FROM jos_content"
           . " WHERE id<>$id "
           . " AND state=1 "
           . " AND access <=$my->gid "
           . " AND (metakey LIKE '%";
   $query .= implode( "%' OR metakey LIKE '%", $likes );
   $query .= "%')";

   $database->setQuery( $query );
   if ($related = $database->loadObjectList() ) {

    foreach ($related as $item)
     {
     echo "<a href=http://banfield/index.php?option=com_content&task=view"
           . "&id=$item->id&Itemid=$Itemid>$item->title</a><br>";
    }
   }
    echo $database->getErrorMsg();
  }

 }
}

?>