[Resolved] Adding numbers stored in SQL

[thehb]

I'm sure this is simple, I'm not sure what function to use for it though. . .

I have a Table with a field call "Duration" which keeps track of seconds. There is also a field "User" to show which user stayed logged in for the "Duration"

I need to add up all the "Durations" for a specific user to create a total number of seconds the user has ever been logged into our system.

Anyone know how to add numbers from a MySQL table ?

[Drakla]

SELECT sum(Duration) FROM wherever WHERE userid=$userid

This is a database question, use the database forum for them in future.

[thehb]

That worked like a charm, thanks!

One question, how do I get the results in variable so I can echo them ?

PS: Didnt know about the database forum, thanks!

[thehb]

Once again, another issue resolved.

Thanks for the help.

<?
$pass1 = mysql_query("SELECT sum(Duration) FROM User_Records WHERE UserID=adminuser");
while ($line = mysql_fetch_row($pass1)) {
 foreach($line as $key => $time) {
	}
}
?>