Hello, Try this: SELECT SUM(duration) AS summ, ..., ..., ..., FROM table1 WHERE condition Hope it will help ya!
Regards, Denis Basta. "Adi" <[EMAIL PROTECTED]> wrote in message 008701c25ef1$01d94260$9600a8c0@adi">news:008701c25ef1$01d94260$9600a8c0@adi... 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php