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