prepare("select distinct coordstostore,count(coordstostore) as num from heatmap group by coordstostore order by num desc"); $get->execute(); while ($row = $get->fetch()){ echo $row[0].' ,'.$row[1].'
'; } //rules 1-2 clicks = gray 2+ clicks red ?> This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph. This is a paragraph.This is a paragraph. This is a paragraph. This is a paragraph.