Login  |  Register
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome, Guest. Please login or register.
Did you miss your activation email?

December 09, 2022, 06:29:58 PM

Login with username, password and session length
Members
  • Total Members: 3853
  • Latest: tty456
Stats
  • Total Posts: 193628
  • Total Topics: 21108
  • Online today: 56
  • Online ever: 3540
  • (September 02, 2022, 06:38:54 PM)
Users Online
Users: 0
Guests: 63
Total: 63

Author Topic: [Reguest] Tag Cloud snippet  (Read 73140 times)

0 Members and 1 Guest are viewing this topic.

JPDeni

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #20 on: March 05, 2007, 05:59:08 PM »
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

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #21 on: July 01, 2007, 06:12:12 PM »
thanks tiny portal i have been drinking coffee all day working trying to figure this out ..........
thanks alot you guys rock

cheers

forumsbg.net

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #22 on: July 03, 2007, 06:44:04 AM »
10x for the code i'll use this for sure

3nd3r

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #23 on: August 22, 2007, 04:33:37 AM »
Thanks for this! It works like a charm!

Congrats JPDeni !!

3nd3r

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #24 on: August 22, 2007, 04:58:26 AM »
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

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #25 on: August 22, 2007, 07:14:58 AM »
You could try changing

Code: [Select]
ORDER BY l.ID DESC LIMIT 50

to

Code: [Select]
ORDER BY t.tag LIMIT 50

3nd3r

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #26 on: August 22, 2007, 07:48:00 AM »
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

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #27 on: August 22, 2007, 07:51:17 AM »
Try

Code: [Select]
ORDER BY t.tag ASC LIMIT 50

3nd3r

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #28 on: August 22, 2007, 09:31:55 AM »
Simply perfect! :D Thank you very much!

3nd3r

  • Guest
Re: [Reguest] Tag Cloud snippet
« Reply #29 on: August 27, 2007, 05:53:45 AM »
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:
Code: [Select]
ORDER BY l.ID, t.tag ASC LIMIT 50";and this:
Code: [Select]
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.