Run another query and let MySQL add it up. > -----Original Message----- > From: Jason Pruim [mailto:japruim@xxxxxxxxxx] > Sent: Thursday, September 25, 2008 10:05 AM > To: PHP General List > Subject: Math problems (No not high school math!) > > So I'm trying to figure out how to do a little math in php to add up > the number of hours that people have worked (Still on the timecard for > anyone following along at home) > > I have it inserting time in and timeout as timestamps into a MySQL > database, from there, I use a while loop to display the total hours > for the day which works perfectly, now though, they want it to total > for the week... > > I think what I need to do is create an array of my total time for the > day then add that up in another loop to display the total... That > seems like overkill to me though... is there a better way to do it? > > Here is the relevant part of the code: > > while ($row = mysql_fetch_assoc($result)){ > $timein = date("m/d/y h:i:s", $row['timein']); > $timeout = date("m/d/y h:i:s", > $row['timeout']); > $totalday = ($row['timeout'] - $row['timein']); > $totalday = $totalday/60/60; > $totalday = round($totalday, 2); > $totalweek = > ?!@?#!@#?!@#!$%^!23?!@#!@#?!@#?#$&*^ > > echo <<<ADMIN > > > <tr> > <td>{$row['Name']}</td> > <td>{$timein}</td> > <td>{$timeout}</td> > <td>{$totalday}</td> > > </tr> > > ADMIN; > } > echo "</table> > </div> > </body>"; > > -- > > Jason Pruim > Raoset Inc. > Technology Manager > MQC Specialist > 11287 James St > Holland, MI 49424 > www.raoset.com > japruim@xxxxxxxxxx > > > _______________________________________________________ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
