Adding times together

Phily_Baby

I have a page that displys song lyrics stored in a database. It's a bit sketchy as I've only spent a few hours on it. I want to display the total time for all tracks in an album. I have the times for each track stored in the database in the time format (00:00:00) and I can access them fine in a while loop. What I don't know how to do is add them together so that 3min21sec + 1min12sec = 4min 33sec.
So far I have this:

while($album_songs = mysql_fetch_row($lyrics_result)) {
  $album_len = $album_len + $album_songs[3];
  echo "$album_songs[3] - $album_len<br>";
  echo "<b>$album_songs[0] - $album_songs[1]</b> - <i>$album_songs[3]</i>".
    "<br>\n";
}

echo "$album_songs[3] - $album_len<br>";
this displays the song length in time format but $album_len is always 0.
The page

Is this possible or is there an easy way todo it?

Thanks

~Phily

diego25

PHP doesn't understand the colon inside the time. So it will try to interpret the number up to whatever it can't interpret. In your case, all your times start with "00:", so it always returns 0. You can use explode() to get the hour, minute, and seconds separated, and then add them up individually.

Diego

sijis

i dont know if this will help, but you can try to use:
mktime()
i was thinking you can add all the totals of time then input them into mktime() and format the total.
not exactly sure how it's gonna turn out or if it even is a good idea, just a suggestion.

http://www.php.net/manual/en/function.mktime.php