Re: [PHP] time to seconds

[mhafizm]

select time_to_sec('00:12:30) ?? 
 
  
 From: adi [EMAIL PROTECTED] 
 Date: 2002/09/18 Wed PM 04:54:31 CST 
 To: PHP-General [EMAIL PROTECTED] 
 Subject: [PHP] time to seconds 
  
  Hi, I have a table table1, with a column Duration time type(ex 00:12:30) 
 I want to make in PHP a sql selection: 
 SELECT * from table1 WHERE condition, and after that, to make sum of values 
 of column Duration and display it. 
 Any Help? 
  
 How to transform time in seconds, with php functions? 
 tx 
  
  
  

saYANg forever!


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] time to seconds

[Warren Daly]

if your data is in UNIX TIMESTAMP format:

$result = mysql_query(select * from table1;,$db);
while ($row = mysql_fetch_array($result)){
// convert seconds from epoch into human date //
$data[] = date(Hi,mktime(0,0,$row['duration'],1,1,1970));
}

so I guess using mktime to convert DATE into unix timestamp

///mktime to recreate the unix timestamp
$result = mysql_query(select * from table1;,$db);
while ($row = mysql_fetch_array($result)){
$data[] =  mktime($hours ,$minutes, $seconds,$month ,$day,$year);
}

to sum the row you would need to add something like this.

$result = mysql_query(select * from table1;,$db);
while ($row = mysql_fetch_array($result)){
$var = $row['duration']
$sum = $var + $sum
}
echo $sum

but I'm sure other people have much better ways of doing it:) it's a bit
early in the morning for me
hope this helps.
Warren 

-Original Message-
From: adi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 9:55 AM
To: PHP-General
Subject: [PHP] time to seconds


 Hi, I have a table table1, with a column Duration time type(ex
00:12:30)
I want to make in PHP a sql selection:
SELECT * from table1 WHERE condition, and after that, to make sum of
values
of column Duration and display it.
Any Help?

How to transform time in seconds, with php functions?
tx




smime.p7s
Description: application/pkcs7-signature