Re: Time Tracking Mechanism PHP/MySQL

by "Ryan Fischer" <ryan(at)gigabee.com>

 Date:  Sat, 27 Jul 2002 16:07:22 -0400
 To:  <hwg-techniques(at)hwg.org>,
"Anthony L. Gloster,
Jr." <alg2(at)alg2.com>
 References:  alg2
  todo: View Thread, Original
> Hello all,
>
>   I have just started toying with PHP/MySQL seriously. My wife and I
are
> currently training for a triathlon this coming spring. We are looking
for a
> way to track our progress (we are currently recording our swim, bike,
and
> run times using microsoft excel breaking i down to the
minute/second/tenths
> and hundreths per mile or km).
>
> I was wondering if anyone knew of any way to track this progress using
> PHP/MySQL so that I could enter the distance and the time in which
that
> distance was covered, and have this program/script convert the average
> MPH/KMPH and total distance for the day/week/month.
>
> We would like to set this up on a page on our site so that we can
share our
> progress it with our friends and family.
>
> Thanks in advance for any suggestions/help given.

The answer is "yes," of course you CAN do it, it's just a matter of
doing it, really.  It seems like you know what needs to be done, and
anything you're asking whether or not it CAN be done can be done, so I'm
really curious as to what your question is.

If it's a matter of "how," well, that's really up to you.  There's more
than one way to do anything.  Some people have a "best" way of doing
things for themselves; you just have to figure out what that is.  Me,
I'd store all values based on the smallest unit possible, and the of
course, you'd use PHP to print out whatever you can.  The possibilities
are endless, so asking us how you should go about doing things really
isn't going to help.  Because like I said, it's up to you.  :)

-Ryan

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA