$q->execute();
while (my @row=$q->fetchrow_array()){
$data{$row[2]}->{$row[1]} = $row[0];
}
$q->finish();
LRMK
- Original Message -
From: "Wiggins d Anconia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 16, 2004 9:59 PM
Subject:
> [..]
> > I will try and explain again what I am trying to do.
> > I read in a file with a list of
> > roomsThen im trying to list the room once and then count
> > how many records match for the select statement and only
> > print the building once with a count in front of it..
> >
> >
[..]
> I will try and explain again what I am trying to do.
> I read in a file with a list of
> roomsThen im trying to list the room once and then count
> how many records match for the select statement and only
> print the building once with a count in front of it..
>
> db:
> date build
D:211
11BLD:333
For 20 :
1BLD:1544
2BLD:1544
My goal was to have this output:
For 30 :
10BLD:211
1BLD:333
For 20 :
2BLD:1544
Thanks..
-Original Message-
From: Wiggins d Anconia <[EMAIL PROTECTED]>
Sent: Jun 16, 2004 7:23 AM
To: rmck <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subj
> Im trying to list a record once and then count how many records. But I
keep getting a list of all the records and it counts those?? I read in a
file with a list of rooms and then look for each one that matches dept
22 and Im trying to show it once and then count how many for the building?
>
>
>
Im trying to list a record once and then count how many records. But I keep getting a
list of all the records and it counts those?? I read in a file with a list of rooms
and then look for each one that matches dept 22 and Im trying to show it once and then
count how many for the building?
#!/u
