Getting data from a table, problem is probably stupidity(Yes it was, fixed now)

Can't Post

I'm trying to get info out of a database. The testing table I have has one data entry, URL, and I cannot get it out in perl.

This is the code: http://pastebin.com/7gaYceAY This is where you can view the output: http://uf.serveftp.com/cgi-bin/display.cgi

I'm using \n instead of <br /> right now as I've been running it like a perl script so I can get more error messages.

But what I need to know is how I'm supposed to get the data out of the table after I execute the SQL query. I've just been copying things off different tutorials and modifying the variable names so they work, but none have worked.

Okay, thank you very much. I had wondered why I used the database handle instead of the query, but the two tutorials I had looked at used the database handle.

And yeah, I've learned perl by looking at the code my friend wrote, and getting him to explain it to me and then working off tutorials and assuming things from other languages. It worked till databases, where I was just copying tutorials.