Counting Results

SureFire

I need to show the top five tutorials on my site.

Everytime a tutorial is viewed an entry in my STATS table is added.

The entry includes an autoindex called statid, and an index called TUTORIALID is also added. The last thing thats added is the tutorial name in a field called NAME

I have the following code that successfully prints all the number of views, but I need it to order the views and display the last five in descending order displaying the name instead of the count.

<?

mysql_connect(localhost,$username,$password); 
@mysql_select_db($database) or die( "Unable to select database"); 
$query = "SELECT name, COUNT(*) as numArticles FROM stats GROUP BY tutorialid ORDER BY name ASC";  

$results=mysql_query($query); 

mysql_close();



$i=0;
while ($row = mysql_fetch_array($results)) {

echo "




$row[numArticles] ";


++$i;
}


?>

Any help would be appreciated, thanks!

bad76

Hi,
you mean this ?

$query = "SELECT name, COUNT(*) as numArticles FROM stats GROUP BY tutorialid ORDER BY numArticles DESC LIMIT 0,5";

SureFire

Amazing! not only you deciphered my drunken post, but you got my problem halfway solved!😃

Now it only prints 5 results, and they are in descending order, just like I asked.

But it still prints just the number of views instead of the tutorial name, I tried this, but It didn't work..

$name=mysql_result($results,$i,"name");

Then I put an echo statement with $name in it.

I feel I'm really close, but obviously I'm a little off.

Thanks Man!

tekky

so use...

echo $row['name']." viewed " .$row['numArticles']. " times.<br>\n";

SureFire

GEEZ, its like you guys answere before I even get done typing!

Thanks a million!

PS I'll click on thread resolved, but it never works for me.

tekky

Originally posted by SureFire
GEEZ, its like you guys answere before I even get done typing!

Thanks a million!

PS I'll click on thread resolved, but it never works for me.

hehe, I generally have nothing better to do at "work" than browse the forums 😉

DSMtalk used to be my home at work... but I'm getting rid of the car hopefully, so PHPbuilder has to put up with me now 😃

SureFire

Well I, for one, am glad to have you!