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
