personally, I prefer to use methods prepare() and execute() which makes it really easy to re-use queries and whatnot. After this point...

To get one row into hash references:
------------------------------------

my $row = $sth->fetchrow_hashref;
Then grab your values with:
$row->{'my_column'}
[download]

For multiple rows in hash references:
-------------------------------------

while(my $row = $sth->fetchow_hashref)
     $row->{'my_column'}
[download]

Take a look at the function definitions that come with DBI for explicit definitions, but you can fetch rows in a number of ways with hashes and arrays. DBI ROX!!!

--Andyram27--