I have created a couple of fansites now on my favourite music artists and I do the menu on the left hand side of the page. You can see the menu on one of them here: http://www.chamillionairechat.com

Anyway I am getting more and more people who want to affiliate with me and it takes me a long, long time to add their link into the box as there is hundreds of pages like all the lyrics page.

Anyway I was just wondering is it possible for me to do this a quicker way by using SQL

I haven't really used it before except for some phpbb mods

Thanks, Daniel Mousdell

Yes, but not purely by using SQL. A relational database is a backing store. It's sort of like saying that your DNA is the magic "breath of life" that makes you who you are, but you could take the information in your DNA, write it down on paper, and have nothing. Information in a database is like that, until you put it to use.

What that means is that you can store all the URLs you want in a table in a database, but you also need some PHP (or ASP.NET to be modern) code to pull those URLs out of the DB, and write them into the page as hyperlinks.