Hi there,
i have query which returns multiple rows.
example:
i have a query like "select item, quantity from inventory;"
this returns the rows:

item    quantity 
-----   ---------
orange    15 
tuna      30 
chops     50
[download]

now i want to get the item as the key and quantity as the value.
for example like:
$hash{tuna} should give me 30;
so how do i do that. Your help would be greatly appreciated. thanks - anjaana.
Note: i was not sure if this question was for hashes or databases so i put in both.

Originally posted as a Categorized Question.