[PHP] Re: time to seconds

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

Re: [PHP] 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.