[Resolved] Count Help

[erikhillis]

hey, I'm sure this is pretty easy for some... but how do I count numbers in my database...

For example:
I have a table called "downloads" and a row called "hits". As you can guess, its for a download database. How would I count the total number of hits for all the rows in my table?

Thx

[broc7]

SELECT SUM(hits) FROM table

You can add where clauses to narrow the count too.

[tekky]

I would also recommend doing it as...

SELECT SUM(hits) AS total FROM downloads

that way you can reference the value as 'total' in your results var

[erikhillis]

This:

<?php
// Connect to the database
$db = mysql_connect("localhost","---","---"); 
mysql_select_db (---);
$result = mysql_query("SELECT SUM(hits) FROM links");
print $result;
?> Hits.

Brings up:
Resource id #8 Hits

Any ideas?

[tekky]

yes...

mysql_fetch_assoc()

[erikhillis]

Sry, still not working. Can you put that into my code please?

[tekky]

<?php
// Connect to the database
$db = mysql_connect("localhost","---","---"); 
mysql_select_db (---);
$result = mysql_query("SELECT SUM(hits) AS totals FROM links");
while($row = mysql_fetch_assoc($result))
{
  print $row['totals'];
?> Hits.

there ya go 😉

[erikhillis]

Thanks alot 🙂

😃😃😃

[tekky]

heh, sure 🙂