[RESOLVED] Totals from database

[darylr]

Hi all,

A new problem im afraid :rolleyes:

In my database, I have users who each have a certain amount of minutes logged.

What I want to do is display the total amount of minutes everybody has logged collectively.

Can someone help me with some code that will add all the minutes of each user together?

The furthest I've got in selecting the minutes from the database table :o

Thanks,

Daryl

[laserlight]

A single simple SQL statement like:

SELECT SUM(logged_in_time) FROM tablename;

should be sufficient.

[darylr]

Hiya,

Still a bit unsure.. I have this code and its not working;

mysql_select_db($database_conn_reava, $conn_reava);
$query_pilots = "SELECT * FROM pilots";
$pilots = mysql_query($query_pilots, $conn_reava) or die(mysql_error());
$row_pilots = mysql_fetch_assoc($pilots);
$totalRows_pilots = mysql_num_rows($pilots);

$minutes = $row_pilots['hours'];

$query_hours = "SELECT SUM($minutes) FROM pilots";
$totaltime = mysql_query($query_hours, $conn_reava) or die(mysql_error());

Im echoing $totaltime then on the page to try display the amount.

[laserlight]

More like:

$query = "SELECT SUM(hours) FROM pilots";
$result = mysql_query($query)
	OR die(mysql_error()); // for debugging
$totaltime = mysql_result($result, 0);

[darylr]

Thanks laserlight - that did the trick 😃

D.