anyone here with mysql knowledge? I have a mysql databse thats displays in a web page as a table, one of the columns is 'duration' (as in minutes & seconds). I want to display the total sum of this column, at the bottom of the page. So when you alter a duration in the field, it automatically adjusts the total duration at the bottom. the calculation must take into account it's dealing with time, not normal sum function. am i making sense? I am to me.