Top Rated Block

[DGTALGOODIES]

Hi can some one help me make the Top 10 block into Top Rated i kinda have an idea but it does not work right.

$query = "select * from idx_link
where suspended = 0 and rating = 1
order by rating desc, last_updated desc limit $params[max_item]";

Thanks in advance.

Sorry!

This works
$query = "select * from idx_link
where suspended = 0 and rating
order by rating desc, last_updated desc limit $params[max_item]";

[Bruceper]

You are so overthinking this.


<%block_rss_feed url="<%$site_url%>/rss.php?type=top" template="block.rss_feed.html" max_item="5" cache_time="86400"%>

Done

[DGTALGOODIES]

You are so overthinking this.


<%block_rss_feed url="<%$site_url%>/rss.php?type=top" template="block.rss_feed.html" max_item="5" cache_time="86400"%>

Done

LOL what u mean i am overthinking this, i tough i did it the right way. Its working!

Iam using this

$query = "select * from idx_link
where suspended = 0 and rating
order by rating desc, last_updated desc limit $params[max_item]";



How is this <%block_rss_feed url="<%$site_url%>/rss.php?type=top" template="block.rss_feed.html" max_item="5" cache_time="86400"%>
supposed to do the same thing!

[Bruceper]

You say you want a top rated block, so I told you how to do it that takes no thinking and no work other than copy/paste.

If you want to try and code it out, and get the same results, that would be overthinking it. It's a lot easier to just use the available rss feed.

[DGTALGOODIES]

I see but unfortunately the over thinking way is the only way i can get it to work i tried pasting your code but it does not work it shows partials text of the code prabably due of my lack of skills but its all good it works and i dont need the Top 10 block

Thanks