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!
No comments posted yet
Your Answer:
Login to answer
121
6
Other forums
New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan
Remove directories not empty
hi,
i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.<
Help with syntax
Hi all!
The $bridge variable is not getting passed while it is contained in the line below:
PHP time (deadline within one week)
I have a column ['projdue'], which stores the deadline for a project.
I have PHP code and <
add text and number image
hi guys ..
ok see i want the user to add their name and pick a number then click get it and i
Syntax error
hi im having a little trobble with this script
-------------------------------------------------
mysql query with single quotes in a variable
$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$u
Retrieving the 25 most recently added entries from all tables in a MySQL databas
Hello,
The code below works great. It creates a table that shows the 25 most recently added t
mod_rewrite.c on windows ??
why it's not working on windows while it's working on other hosts???
this is the code i got
Echoing If Function?
A script I am using has If statements in the comments form to basically tell the form what to do. Cu