List:General Discussion« Previous MessageNext Message »
From:Douglas Brantz Date:July 15 1999 3:10pm
Subject:Re: Sum of seconds?
View as plain text  
Thanks, it works fine.

But now I am having trouble putting this into a perl file for it to
work.

What would the syntax be for putting that into a fetchrow or do I need
it in a fetchrow?
Here is what I am trying.  I am very new at this.

my $i="";
$i=1;
while (@record = $sth$i->FetchRow)  {
my $sth$i = $dbh->Query("select
SEC_TO_TIME(sum(outtime-intime)),firstn,lastn from
monitor where lastn=\"$lastn\" and firstn=\"$firstn\" group by lastn ")
or die $Mysql::db_errstr;
$total,$firstname,$lastname = $record[0]; $bar = $record[1];
$i++
}
print "$total, $firstname, $lastname</td><td align=center>";

Thanks

Douglas


--

Douglas Brantz
Computer Consultant
Fine & Applied Arts
Appalachian State University
Boone, NC 28608

828-262-6312 FAX
828-262-6549 OFFICE
brantzdr@stripped


Thread
Sum of seconds?Douglas Brantz15 Jul
  • Re: Sum of seconds?Sasha Pachev15 Jul
  • Re: Sum of seconds?Douglas Brantz15 Jul
    • Re: Sum of seconds?Paul DuBois15 Jul
  • Re: Sum of seconds?Jim Faucette15 Jul