hi all,
i am trying to access the results of a query made to a mysql db.
the query is
====================query code==========================
my $incoming = "SELECT sum(bytes_in),sum(bytes_out),sum(msgs_in),"
."sum(msgs_out)"
." from trafficperhour WHERE time >= $BeginHour and time"
." < $EndDay;";
=========================================================
then i tried to access the results with the following code but realized
the query was returning something like sum(msgs_in) sum(msgs_out) etc.
==========================================================
while ( my $row = $sth->fetchrow_hashref )
{
$Msgs_In=$row->{msgs_in};
$Msgs_Out=$row->{msgs_out};
$Bytes_In=$row->{bytes_in};
$Bytes_Out=$row->{bytes_out};
}
============================================================
and therefore $Msgs_In, $Msgs_Out ... are empty. can someone tell me where
i can find info on how to access the results of my query?
thanks
--
- josh
N8MSO
20A8 2FC6 9099 D215 78F4 D005 B9F3 21C4 300C C25E ~. .~ Tk Open Systems
=}------------------------------------------------ooO--U--Ooo------------{=
- [EMAIL PROTECTED] - tel: +972.58.520.636, http://www.tkos.co.il
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
