Code:
ORDER BY `anzahl` DESC
<?php
$sql = "SELECT keyword, COUNT(keyword) AS anzahl FROM stats GROUP BY keyword ORDER BY keyword";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($result);
do {
echo "<tr ><td width=60%".$row['keyword']."</td>";
echo "<td width=40%".$row['anzahl']."</td>";
echo "</tr>";
}
while($row = mysql_fetch_assoc($result))
?>
SELECT keyword, COUNT(keyword) FROM tabelle
SELECT keyword, COUNT(keyword) FROM tabelle
Einen Kommentar schreiben: