";
echo $row['name']."'s top 25 favorite colors (by pixel):
";
while(list($hx,$spx)=sqlgetrow($res)) {
echo "| ";
percentagebar(100,$hx); echo " | $hx ($spx)
";
echo " |
";
}
echo ' | ';
$res=sqlexec("select hexcolor,count(p.pictureid) as spix
from histograms h,pictures p
where p.userid=".$row['userid']." and
p.pictureid=h.pictureid
group by hexcolor order by spix DESC limit 25");
echo $row['name']."'s top 25 favorite colors (by picture):
";
while(list($hx,$spx)=sqlgetrow($res)) {
echo "| ";
percentagebar(100,$hx);
echo " | $hx ($spx)
";
echo " |
";
}
echo " |