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" <[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