[PHP-DB] Dealing With MySQL's new Time Calculations

I have an interesting problem I'm trying to solve. Right now, I'm keeping track of sessions starting and ending times with a PHP datetime field, and calculating the total time spent in all sessions with the new PHP time command... something like this: $total_minutes = mysql_query(select

Re: [PHP-DB] Dealing With MySQL's new Time Calculations

Set your select to group by userid, select on min(tourney.start) value and max(tourney.start) value where closed = 1 etc. graeme. [EMAIL PROTECTED] wrote: I have an interesting problem I'm trying to solve. Right now, I'm keeping track of sessions starting and ending times with a PHP datetime

Re: [PHP-DB] Dealing With MySQL's new Time Calculations

Sorry that should have been max(tourney.finish) :-[ graeme graeme wrote: Set your select to group by userid, select on min(tourney.start) value and max(tourney.start) value where closed = 1 etc. graeme. [EMAIL PROTECTED] wrote: I have an interesting problem I'm trying to solve. Right now, I'm