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.

Did you know?Explore Trending and Topic pages for more stories like this.
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!
No comments posted yet

Your Answer:

Login to answer
121 Like 6 Dislike
Previous forums Next forums
Other forums

MII Trends - add data onto chart object
Hello,

Can anyone please provide some thoughts on my current requirement:
its pretty

Create a form of 2 numbers input and find the greatest.
Hi, everybody.

I have a homework in my training of php, which ask you to make a form that ask

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

Is there a function ... auto send IP
Is there some function that can be sent to a ddns service that returns the ip address of a ddns forw

mysql_real_escape_string
Let me preface this that I am very much a PHP noob, but I have some SQL training (not necessarily My

OOP help
okay so i have a class im making it has everything setup i just need to randomize the 2 variables an

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

How to ask a regex question?
Hi, I thought I'd share some of my insight after seeing too many bad questions that either get ignor

help understanding hidden input w/ php
hello i'm doing a tutorial where there are multiple forms for an edit page for a user to update thei

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash