I'm new to mySQL, so I need some help retrieiving the stored data in the table.

Ok I've got 5 columns: id, url, title, and descrip.

How can I retrieve the information for the columns from each row?

So that it does something like this:
while (there are still some rows to get information from){
echo ("<a href='$url[0]'>$title[0]</a><br><small>$descrip[0]</small><br><br>");
I found out that getting information from mySQL dbs is harder the sending information to mySQL dbs. In my opinion, anyways.

Thanks for the help.

Suggestions for different methods and flames are welcome!