top 10 clickers via count function

[bigfatwallet]

Hi there,

I would like to display a table that might look as follows in my browser:

Username Clicks
abcde 100
dfgert 85
rthxdgjn 61

The mysql code I have so far is as follows (Please note the two variables will be variables from a previous mysql_query but I 'should' be ok sorting that out):

PHP Code:
 SELECT username, COUNT( * ) AS clicks FROM ptchistory  

WHERE date > $startdate AND date < $enddate 
GROUP BY username 
ORDER BY clicks DESC LIMIT 10  

I cannot get the resultset to output in a browser window and send my thanks in advance for any help offered.

Thanks

[devinemke]

<?php
$result = mysql_query("SELECT username, COUNT(*) AS clicks FROM ptchistory WHERE date BETWEEN '$startdate' AND '$enddate' GROUP BY username ORDER BY clicks DESC LIMIT 10") or exit(mysql_error());

echo '
<table border="1">
<tr>
<td><b>Username:</b></td>
<td><b>Clicks:</b></td>
</tr>
';
while ($row = mysql_fetch_assoc($result))
{
	echo '
	<tr>
	<td>' . $row['username'] . '</td>
	<td>' . $row['clicks'] . '</td>
	</tr>
	';
}
echo '</table>';
?>

[bigfatwallet]

You are a star - Thank you so much - works perfectly.

🙂 🙂 🙂