How to make a Cloud text from database

[jrahma]

Hi,

I have skills saved in a table called skills in mysql with field name called skill_name.

I want to retrieve the skills and display like a cloud so one will have small font and next one will have larger font, etc..

something like this image:

http://www.rmc.bh/temp.jpg

can anyone guide please..

[Derokorian]

I'm not sure if this helps or not, but if you set a min and max font size you can rand a size for each word. Something like:

<?php

$min_font = '7';
$max_font = '11';

$qry = 'SELECT skill_name FROM skills';
$result = mysql_query($qry);
if( !$result ) trigger_error(mysql_errno() .' - '. mysql_error());
if( mysql_num_rows($result) !> 0 ) trigger_error('No results');
while( $row = mysql_fetch_assoc($result) ) {
   echo '<span style="font-size:'. rand($min_font,$max_font) .'pt">'.$row['skill_name'].'</span>';
}

[NogDog]

Is there some criteria that is supposed to determine which skills are displayed larger (e.g. frequency of appearance in the table or some other column in the table (or another related table) upon which to make that determination?

[jrahma]

NO criteria..