Re: Building a tag cloud from a database

Depending on the database, you could do this:

SELECT word, occurrences FROM statistic ORDER BY occurrences DESC LIMI
+T 200
[download]

Also, most databases will provide some amount of mathematical functioning for you and, in some cases, it can be much more efficient. Just make sure you comment the heck out of the SQL.

And, the last problem is:

$dbtags{$word} = $occurrences;
[download]

My criteria for good software:

Does it work?
Can someone else come in, make a change, and be reasonably certain no bugs were introduced?

Comment on Re: Building a tag cloud from a database Select or Download Code

Replies are listed 'Best First'.
Re^2: Building a tag cloud from a database by jdporter (Paladin) on Apr 29, 2008 at 13:46 UTC
Just make sure you comment the heck out of the SQL. Better yet, don't put the heck in your SQL in the first place. It would only confuse those who have to maintain the code later. `;-)` [download]	[reply] [d/l]
Re^3: Building a tag cloud from a database by Anonymous Monk on Apr 30, 2008 at 08:00 UTC
Not if you hire a heckler	[reply]