in reply to how to deal with multiple results returned by select statement
I routinely use fetchrow_hashref.