Re: Query database

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~~

Comment on Re: Query database Select or Download Code

Replies are listed 'Best First'.
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]

Replies are listed 'Best First'.

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]

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]