Sum total time column with PHP.

[hasamba]

Hi all.

 

I'm a newbie to PHP and Mysql, and I hope you can help me.

I have a table called "jos_log", in that table I have a column called "total" which stores total time like this 14:00.

I need a PHP script that can sum that time column and display it in a text box called "total_time".

 

Looking forward to hear from someone

 

Cheers. Hasamba

[The Little Guy]

you should really store the date in the database as a timestamp, which would be formatted like so:

YYYY-MM-DD HH:MM:SS

 

eg.

2001-03-09 22:46:30

 

That would make it much easier to calculate times.

[Muddy_Funster]

If you're looking for a PHP script, wouldn't it have made more sense to post in the PHP Help section instead ?  What field type is total just now? and what type of duration are you reffering to by 14:00?  hours or minutes?

[hasamba]

Hi,

 

The total field is also TIME.

I already have a PHP script that calculate startTime and endTime and gives me the Total for each row.

Now I need a PHP script that will automatic SUM the column Total in DB and will represented the SUM in a text field. The format should be HH:mm.

One thing I forgot to mansion! I'm doing this to save my Filght Time (I'm a Pilot). Which means, The SUM time is a lot higher the 24:00. Right now I have 60:00 hours.

 

Do you think I should move it to the PHP section?

[Pikachu2000]

No need to post in more than one forum, as it violates the forum rules and TOS. You can do this in the query without a problem.

 

SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(`total_time`))) FROM `table` WHERE . . .