List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 14 1999 4:58pm
Subject:Re: Fetchrow for listing names
View as plain text  
Douglas Brantz wrote:
> 
> Hello,
> 
> I would like to create an output list to a web page of users with their
> total time monitoring a lab.
> Users clock in and clock out and I don't have a set list of monitors or
> users, but I would like to run fetchrow and grab all the last names of
> all the users that monitor the lab and next to that I would  like to
> post the total time they worked.  My question is can I use one fetchrow
> statement to grab the SEC_TO_TIME(totaltime) where
> lastname=\"\$lastname\";
> print lastname and totaltime;
> 
> I am using mysql 3.22.15 on Redhat5.2 with Apache.  Thanks in advance.
> 
> Douglas

If I have understood it right, you need a combination of order by
<col_name> desc and limit.
 
-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
Fetchrow for listing namesDouglas Brantz14 Jul
  • Re: Fetchrow for listing namesSasha Pachev14 Jul