TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

March 29, 2024, 07:24:15 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,106
  • Total Topics: 21,213
  • Online today: 358
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online

[Reguest] Tag Cloud snippet

Started by soMzE, February 28, 2007, 06:11:07 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

JPDeni

I'm sorry. I was thinking of the Poster Cloud. Too many clouds! :)

Yes, the tags should be different sizes, depending on how many posts there are with each tag. I know that it worked for soMzE, because I saw it on his site. Can I get a link to your site?

bathgate

thanks tiny portal i have been drinking coffee all day working trying to figure this out ..........
thanks alot you guys rock

cheers

forumsbg.net

10x for the code i'll use this for sure

3nd3r

Thanks for this! It works like a charm!

Congrats JPDeni !!

3nd3r

Just began to use your fantastic block code, I've have one question:

Is it posssible to show the tags in alphabetical order instead the actual one (new tags first)?

Thanks in advance for your time

JPDeni

You could try changing


ORDER BY l.ID DESC LIMIT 50


to


ORDER BY t.tag LIMIT 50

3nd3r

Thanks for your quick answer.

It's ok... But the order is reversed... I mean it's Z-A instead of A-Z

Thnak you again for your time

JPDeni


3nd3r

Simply perfect! :D Thank you very much!

3nd3r

Excuse me for annoying you with my requestings. I'm not an SQL expert and I'd like to make you another question...  ::)

So, I want to show "N" tags in my block, and I want to show most popular ones and alphabetically...

I was trying this:
ORDER BY l.ID, t.tag ASC LIMIT 50";
and this:
ORDER BY t.tag, l.ID ASC LIMIT 50";

but none of these works like I want...

Sorry for disturbing you with my askings. Take your time for this. I'm not in a hurry.

Thanks in advance for your time JPDeni.