add up mysql row and then echo the result

webandwe

Hi,

I have a database with a row called "time".

I need to somehow add up all the time rows and then echo out the total. How do I do it?

Example

MySQL
-----------
1. time 30
2. time 10
3. time 20

php
----------------

$total_time = ( addup all SQL rows FROM Time);

echo"$total_time min";
---------------------------------

Result:

60 min

Thanks

Atli

What type of a column is it? DateTime? Int?

pbmods

Heya, webandwe.

Have a look at MySQL's date and time functions.

webandwe

Hi, it is just a varchar....

I have a script that converts the numbers into time....I just need to write a php script that add's up all the number and then echo it out...I will hande the results from there.

entertainmentliveuk

Quote:

Originally Posted by webandwe

Hi,

I have a database with a row called "time".

I need to somehow add up all the time rows and then echo out the total. How do I do it?

Example

MySQL
-----------
1. time 30
2. time 10
3. time 20

php
----------------

$total_time = ( addup all SQL rows FROM Time);

echo"$total_time min";
---------------------------------

Result:

60 min

Thanks

Try something like this:
[PHP]
$mins=0;
$time = mysql_query("select * from $table WHERE Time> '0' ");
{
while($row = mysql_fetch_array($time))
{
$mins=$mins+$row['Time'];
}
echo $mins." minutes";
[/PHP]

add up mysql row and then echo the result

re: add up mysql row and then echo the result

re: add up mysql row and then echo the result

re: add up mysql row and then echo the result

re: add up mysql row and then echo the result

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about