I take it this isn't running on any dreamhost server as you don't specify a hostname for your database?
You need to select a way of retrieving the information from the database by using anyone of DBI's functions, such as selectrow_array or selectall_array, etc. You can't just say "do this query", DBI needs to know in what format it should return your data.
Check out the DBI documentation on the MySQL website for more information:
Check out the sections labeled:
fetchrow_array, fetchrow_arrayref, fetchrow_hashref
and decide what way you want DBI to return your data. Remember that the easiest format for you to use (hashref), is probably the most costly in terms of overheads. But I wouldn't worry about that now; just get up and running and you can fine tune later.