Show

- 223 Posts
thefutureforward Reply #1, 14 years, 8 months ago

Hi All,

I'm looking to create a "Related Resources" section at the bottom of pages, where 5-10 links would appear for other resources on the site that are "related" to the current page. The related links would be based on the tags assigned to the page, so if I tagged a page "cars" and "women", other pages tagged with those two tags would appear in the related section.

It seems like a fairly common need, so just curious if anyone out there has done something similar. I'm using evo 1.0.5 (too bad..it looks like something similar already exists for revo, in getRelated - http://rtfm.modx.com/display/ADDON/getRelated).

Let me know! [ed. note: presson83 last edited this post 14 years, 8 months ago.]
Nick Hoag
Creative Partner
The FutureForward

http://thefutureforward.com

181 Posts

pagalo Reply #2, 14 years, 6 months ago

If your not to bad with php you could make your own snippet.

<?php
$tvs = $modx->db->select("*", $modx->getFullTableName('whatevertabletheTVtagsarestoredin') ); 

$query  = "SELECT * FROM $tvs ORDER BY item_number DESC";
$result = mysql_query($query);
$tag = $modx->documentObject['tvtag'];
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$catz = $row['tag'];
{
		then make a chunk and display it using echo.
}
}
?>