Aside from the already mentioned fact that you are trying to print $name outside of its scope, I see two potential problems: 1) NUM = '$num' ... numeric values shouldn't be quoted in SQL although your backend may or may not care (which backend, btw?) 2) You can't necessarily depend on the case of the keys in a fetchrow_hashref() unless you have previously declared FetchHashKeyName, see the DBI docs on FetchHashKeyName.