[lavochkin]

Why would a column total reach a number and stop? Pilot Stats

If you would look at the link here and top of page you will Total Flight time. It reads 838:59:59 in a time format 838 hours, minutes , seconds.

Here is problem script I think. reads like this:

$query = "SELECT sec_to_time(sum(TIME_TO_SEC(TotalBlockTime)))FROM flights".$condition;
$result=mysql_query($query);
$TFT = mysql_result($result,0);

Can anyone help me please.

[scott2500uk]

the reason why you are getting this is due to the limit in the datatype of TIME in MySQL

EDIT : nevermind you've made two posts. http://www.hotscripts.com/forums/php...tml#post186046

[wirehopper]

What's the problem?

[Jcbones]

Mysql Bug, answered in the second post.

[wirehopper]

If you change the query ...

PHP Code:

$query = "SELECT sec_to_time(sum(TIME_TO_SEC(TotalBlockTime)))FROM flights".$condition; 

to

PHP Code:

$query = "SELECT SUM(TIME_TO_SEC(`TotalBlockTime`)) AS 'total'  FROM `flights` ".$condition; 

then used

PHP Code:

$hours=$total / 3600;

$minutes=$total % 3600;

$seconds=$total % 60; 

Not tested

[lavochkin]

So it would look like this??

$query = "SELECT SUM(TIME_TO_SEC(`TotalBlockTime`)) AS 'total' FROM `flights` ".$condition;
$hours=$total / 3600;
$minutes=$total % 3600;
$seconds=$total % 60;
$result=mysql_query($query);
$TFT = mysql_result($result,0);

Thank-you

Rick Parkin

[wirehopper]

You have to get the $total from the query.

PHP Code:

$result=mysql_query($query);

$row=mysql_query_assoc($result);

$total=$row['total']; 

[lavochkin]

Great, Now where do I put this:

$hours=$total / 3600;
$minutes=$total % 3600;
$seconds=$total % 60;

Or do I need this with the script you have given me. I am new to this PHP. I have learned by the dummies book. And taken others script and changing it to do what I want.

WireHopper are you for hire?

Best Regards
Rick Parkin

[wirehopper]

PHP Code:

$result=mysql_query($query); 

$row=mysql_query_assoc($result); 

$total=$row['total']; 

$hours=$total / 3600;

$minutes=$total % 3600;

$seconds=$total % 60; 

Not tested

[lavochkin]

Thanks, but that is not going to work. I starting to think that there is no way around this??

It looks like it is counting rows?? answer is 1

Thank-you for time and effort.

Best Regards,
Rick Parkin