Re: Re: time to seconds

won't help, it's forbidden to mix aggregate columns with non aggregate without a group by clause. Make your first query and then the sum. Denis Basta wrote:

Hello, Try this: SELECT SUM(duration) AS summ, ..., ..., ..., FROM table1 WHERE condition Hope it will help ya! Regards, Denis Basta. "Adi" <adipublic@home.ro> wrote in message 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