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) o
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
P? Thanks.
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 usin
?
$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());
This isn't working, I get 23:
$total = mysql_result($result
of this from PHP, so 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
-
Be
