[diablo]

i used this

function related_stories($storyid, $related_tags, $category){
// this returns similar stories based on tags in common and in the same category

global $db;
$related_tags="'".str_replace(", ","', '",$related_tags)."'"; // This gives us the proper string structure for IN SQL statement
// Select 10 stories that share tags with the current story and order them by number of tags they share

// $sql = "SELECT ".table_links.".link_title, ".table_links.".link_title_url, COUNT( ".table_tags.".tag_link_id ) AS relevance, ".table_tags.".tag_link_id FROM ".table_tags.", ".table_links." WHERE ".table_tags.".tag_words IN ( ".$related_tags." ) AND ".table_tags.".tag_link_id = ".table_links.".link_id AND ".table_links.".link_status = 'published' AND NOT ".table_links.".link_id = ".$storyid;
$sql = "SELECT ".table_links.".link_title, ".table_links.".link_title_url, COUNT( ".table_tags.".tag_link_id ) AS relevance, ".table_tags.".tag_link_id FROM ".table_tags.", ".table_links." WHERE ".table_tags.".tag_words IN ( ".$related_tags." ) AND ".table_tags.".tag_link_id = ".table_links.".link_id AND ".table_links.".link_id != ".$storyid;


//comment the following line out if you want this to work accross categories
// $sql.= " AND ".table_links.".link_category = ".$category;
$sql.= " GROUP BY ".table_tags.".tag_link_id, ".table_links.".link_title, ".table_links.".link_title_url ORDER BY relevance DESC LIMIT 10";
// echo $sql;
$related_stories = mysql_query($sql);
$related_story = array();
while ($rows = mysql_fetch_array ($related_stories, MYSQL_ASSOC)) array_push ($related_story, $rows);
return $related_story;
}

[Andtony]

Thanks Diablo.
With your code it's working like a charm.

[endph]

still getting a blank related stories portion of my page.

[Geoserv]

Blank for me as well. Anyone on the dev team able to come up with a solution?

Geoserv

[Geoserv]

I think the issue is there is no GROUP BY clause for MySQL to read. There is one in the next set of queries, but you need one in the initial query.

Thats the error I get no matter what I do.

Geoserv.

[kbeeveer46]

It has worked fine for me so I'm not sure how I can solve something that isn't broken for me :/

[boardsource]

Originally Posted by diablo

i used this

thanks, that worked for me

is there anyway that it can work so that it also searches the title

[Geoserv]

Would it matter what version of MySQL was being used?

Geoserv

[timusa]

Does not work for me. http://doveup.com/ I have done as instructed and i am using the latest pligg. Need help please

[kaustic]

How can you hide this if there are no matching tags?