Better Method of a Member Cloud

Posted on 16th Feb 2014 07:03 pm by admin

I assume most people know how tag clouds work, where the tags most used are bigger and the least used tags are smaller. This is the basic function of my member cloud.

I created the code below from scratch, however I'd rather the data compare itself to each other and have the biggest poster the biggest font size (40px) and the smallest poster the smaller font size (15px) and everyone in between where they should be.

Assume the limit was 5 instead of 20 as in the code.
If:
Member 1 has 10 posts
Member 2 has 11 posts
Member 3 has 12 posts
Member 4 has 13 posts
Member 5 has 14 posts

I'd want Member 1 to be 15px and member 5 to be 40px, and everyone in between where they should be (I assume this would involve percentages.)

A more accurate/ more likely example:
Member 1 has 50 posts
Member 2 has 2 posts
Member 3 has 72 posts
Member 4 has 90 posts
Member 5 has 54 posts

I'd want Member 2 to be 15px and member 4 to be 40px, and everyone in between where they should be, regardless of what there actual post count is. I just want smallest smallest and largest largest.




Code: $allmembersresult = mysql_query("SELECT * FROM users ORDER BY RAND() DESC LIMIT 20");
while($row = mysql_fetch_array($allmembersresult)){
$newuid = $row['id'];
$newusername = $row['username'];
$ifadmin = $row['admin'];

$postnumresult = mysql_query("SELECT * FROM content WHERE uid='$newuid' GROUP BY cid");
$postnum = mysql_num_rows($postnumresult);

?>

<a href="/us.php?find=<?php echo $newuid;?>" style="text-transform:none;
<?php
if($postnum == 0){
echo "font-size:15px;";
}else if($postnum > 0 && $postnum <= 5){
echo "font-size:20px;";
}else if($postnum > 5 && $postnum <= 15){
echo "font-size:30px;";
}else if($postnum > 15 && $postnum <= 30){
echo "font-size:40px;";
};

/* etcetc */

if($ifadmin == "yes"){
echo "font-style:italic;font-family:georgia;";
};
if($uid == "$newuid"){
echo "color:green;";
};
?>
">
<?php echo $newusername." (".$postnum.")"; ?>
, </a>

<?php }; ?>

I'd be happy to elaborate if need be! thanks!

Your Answer:

Login to answer

Other forums

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

BAPI BBP_INB_DELIVERY_CREATE - material number missing in delivery
Hi Experts,

I was able to successfully create an Inbound delivery with reference to a PO

Progress bar for webpage
Hi,
I want to implement a progress/waiting bar on my webpage - exactly the same thing that the Mi

Calling strings from other php class
I have test1.php{
$string1;
$string2;
....
... //10 strings in this class <

IIS7 and getimagesize() problem
I have just discovered after hrs of trying to fix a problem where it's coming from. It's to do with

FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<

How To Make More Than One Redirection with PHP on the same page?
Hey im trying to do a direction page where it open differently link direction pages every time som

Posting to another Site?
I have software that people install.
When they install it, is there a way to make it post their d

Generate PDF
Hi guys,

I would like to know if there is a way to generate pdf when clicking on a link. In f

Confusing Functions
So, I've been reading up on Functions and I like them! However, I need some help using variables in