At 11:10 AM -0400 7/15/99, Douglas Brantz wrote:
>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>";
So what happens?
--
Paul DuBois, paul@stripped
