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

session_destroy();
new to php
I have a simple login and am trying to write a logout.
I set a $_SESSION var to 1 i

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Give me all your tricks for minimizing jar file size

Hi, I'm coming close to releasing my J2ME game... I am kicking up against the 64k size barrier w

PHP header help!
Hi all I am trying to get this php page to refresh every 5 seconds on my phone which is an aastra 48

Log $_POST
How would i log submits on a form, by everyone? I want to then echo the number of submissions.

Help with search.php
Hello All

I need the search engine on a site I am building at the moment to display the searc

Is it a good practice to store user info. in sessions?
I am making a user class for my script which stores all the user information in sessions. It takes u

PHP login form help (Done Most of It)
Hi i am having a problem, when i try logging in it is always saying "Invalid Login" im not

Certain files upload, while others do not
I want to read the data from an uploaded file. Not sure why, but it only uploads for certain files.

mail() problem
Hi Guys,

I've set up a contact email form. It sends the information fine, but it sends it to