silentworks

$rels = $this->db->select('rel_parent')->where('rel_child', $userid)->where('rel_type', 'favourite')->from('content_relationships')->get();

$content_ids = '';
$i = 0;
foreach ($rels->result_array() as $row)
{
    if($rels->num_rows() === $i)
    {
        $content_ids .= $row['rel_parent'];
    }

silentworks

$rels = $this->db->select('rel_parent')->where('rel_child', $userid)->where('rel_type', 'favourite')->from('content_relationships')->get();

foreach ($rels->result_array() as $row)
			{
			   $content_ids[] = $row['rel_parent'];
			}

silentworks

			$sql = "SELECT *
			FROM `content`
			WHERE (content_finish >= " . $now . " OR content_finish IS NULL)
			AND `content_status` = 'published'
			AND `content_parent` IN (" . $content_ids . ")
			ORDER BY `content_updated` desc";
			
			$this->db->query($sql);

silentworks

SELECT *
FROM `content`
WHERE (content_finish >= '2011-05-17 23:00:00' OR content_finish IS NULL)
AND `content_status` = 'published'
AND `content_parent` IN ('17', '38', '54', '10', '34', '66', '68', '67', '76', '77', '75', '79', '86', '79', '18')
ORDER BY `content_updated` desc

silentworks

	function mywild($userid = '', $offset = 0)
	{      
		/* find favourites for this user */

		$rels = $this->db->select('rel_parent')->where('rel_child', $userid)->where('rel_type', 'favourite')->from('content_relationships')->get();
		
		print_r($rels);	

		if ($rels->num_rows() > 0) {
		

silentworks

<?php if( ! empty($feed)): ?>
<?php foreach ($feed as $row):?>
	
	<?php if ($row->content_category == 'news') { ?>
		
		<li class="news">
		
			<a class="title" href="<?php echo site_url('news') . '/' . $row->content_id . '/' . $row->content_url; ?>"><h2><?php echo $row->content_title; ?></h2></a>

			<p class="created">News from <a href="<?php echo creator($row->content_parent, 'url'); ?>"><?php echo creator($row->content_parent, 'title'); ?></a></p>