Query database

kapoor has asked for the wisdom of the Perl Monks concerning the following question:

David, After making changes as per your recommendation, my result started displaying:

HASH(0x8d9f80)
HASH(0x8d9fb0)
HASH(0x8d9fe0)
HASH(0x8da010)
HASH(0x8da040)
HASH(0x8da070)
HASH(0x8da0a0)
HASH(0x8da0d0)
HASH(0x8da100)
[download]

before it was displaying:

ARRAY(0x6fa930)
[download]

now it is displaying a hash. To elaborate I am trying to get
data back from database it's a simple query which returns 
mysql> select count(*) from bugs where product_id = 19 and component_i
+d = 271 and bug_status='RESOLVED';
+----------+
| count(*) |
+----------+
|     2957 |
+----------+
[download]

Please assist. thanks!!!

Comment on Query database Select or Download Code

Replies are listed 'Best First'.
Re: Query database by Corion (Patriarch) on Mar 18, 2010 at 21:53 UTC
You're getting an array reference back. Most likely, the documentation tells you that. Also see tye's References Quick Reference, perlreftut and Data::Dumper for inspecting data structures.	[reply]
Re: Query database by ~~David~~ (Hermit) on Mar 18, 2010 at 22:01 UTC
Your `$sth->fetchall_arrayref({});` returns a reference to an array. Instead of doing `print $results;` you should do something like so: `foreach my $result ( @{$results} ){ print $result, '<BR>'; }` [download] ~~David~~	[reply] [d/l] [select]
Re^2: Query database by kapoor (Novice) on Mar 23, 2010 at 19:24 UTC
David, After making changes as per your recommendation, my result started displaying: `HASH(0x8d9f80) HASH(0x8d9fb0) HASH(0x8d9fe0) HASH(0x8da010) HASH(0x8da040) HASH(0x8da070) HASH(0x8da0a0) HASH(0x8da0d0) HASH(0x8da100)` [download] before it was displaying: `ARRAY(0x6fa930)` [download] `now it is displaying a hash. To elaborate I am trying to get data back from database it's a simple query which returns mysql> select count() from bugs where product_id = 19 and component_i +d = 271 and bug_status='RESOLVED'; +----------+ \| count() \| +----------+ \| 2957 \| +----------+` [download] Please assist. thanks!!!	[reply] [d/l] [select]
Re: Query database by desemondo (Hermit) on Mar 19, 2010 at 02:39 UTC
I don't understand what could be the problem In this particular case it wouldn't have helped, but in many many others, `use strict` (which you have commented out) will complain about such things, and save you a lot of time and frustration.	[reply] [d/l]