I have a mysql dbase. I use a time field to save a number of hours (think about number of houres spent out of office, or anything else). A table holds the global values for people and their status, another table holds every single entry of data, so john smith 5 hours and 2 minutes outside on 16-06-2002 james dillon 10 hours and 25 minutes outside on 22-06-2002 and so on. Now i need to update the global values (john smith total hours outside 69:53 for example) according to the single entries. Globally i've already made the algorithm, my problem is: when in php i read a single time value (eg 5:02 for john smith) and add it to the global, it si not calculated in the exact time form. Is it? So what can i do? I can't use a time stamp, because i need only times and greater than 24 houres. So what? Thank you Claudio
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
