RE: difference between two times

2002-03-05 Thread Nathan Cowles
oops, good point. thanks. On Mon, 4 Mar 2002, Roger Baklund wrote: * Nathan Cowles $query2 = SELECT SEC_TO_TIME(TIME_TO_SEC('$lastout') - TIME_TO_SEC('$firstin')); $result2 = mysql_db_query($database, $query, $connection) or die (Error in query: $query. . mysql_error()); You

difference between two times

2002-03-04 Thread Nathan Cowles
if you happen to know of a way to make it do the subtraction in PHP without losing all accuracy, please let me know. Thanks for any help you can offer. Nathan Cowles StormNet Communications 530.897.4069 - Before posting, please

Re: difference between two times

2002-03-04 Thread Nathan Cowles
. Nathan Cowles On Mon, 4 Mar 2002, Paul DuBois wrote: At 13:35 -0800 3/4/02, Nathan Cowles wrote: Paul, You're awesome...thank you. One more question pertaining to this... I'm accustomed to selecting a variable and using something like this: $firstin = mysql_result($result,$row

Re: difference between two times

2002-03-04 Thread Nathan Cowles
The file is available at http://estore.homeip.net/time/pctimesheetnew.php.txt; How would I supply a column alias? Thanks. Nathan Cowles On Mon, 4 Mar 2002, Paul DuBois wrote: At 13:54 -0800 3/4/02, Nathan Cowles wrote: lastout and firstin contain times such as 13:28:01 and 13:27:54