News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Maggie Nelson's Blog:
NTILE() - easy way to generate tag clouds
April 29, 2008 @ 13:44:01

For the Oracle users out there looking for an easy way to pull those tags together and make a handy little cloud out of them, Maggie Nelson has posted about a simple Oracle function that can help - NTILE.

For example, check out the documentation for the NTILE Function. Yeah, sounds kind of boring. What good could it be in the wonderful world of web development? After all, who manages employee or sales tables anymore... Answer: generating tag clouds.

Her SQL statement categorizes the tags for you automatically, dropping them in to "buckets" of font sizes. This makes it simple to loop through them (like with a foreach) and output your tags with a little help from some CSS. You can even specify how many buckets you want it to fill (how many different tag values to get and compare).

0 comments voice your opinion now!
ntile tag cloud tutorial oracle sql order bucket


blog comments powered by Disqus

Similar Posts

PHPMaster.com: Laravel: Is It Really Clean and Classy?

Alison Gianotto: Check User-Submitted URLs for Malware and Phishing in Your Application

SitePoint PHP Blog: Yii 2.0 ActiveRecord Explained

IBM developerWorks: Squash bugs in PHP applications with Zend Debugger

Chris Jones' Blog: Oracle Database and Instant Client 11.2.0.2 are available on Linux


Community Events

Don't see your event here?
Let us know!


api library podcast laravel php7 introduction extension language release opinion security voicesoftheelephpant development version community framework series unittest laravel5 interview

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework