Re: [PHP] Re: time to seconds

2002-09-18 Thread Marek Kilimajer
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 B

[PHP] Re: time to seconds

2002-09-18 Thread Denis Basta
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 colum