Ok, I think I have a small idea on how I can get this thing to work. Ok, I make my database. I make one table for my index to store links to the html or php outputs, that way I can have the actual site be in layers (home > lyrics > artist > blah)

Then I can make another table to store the artist pages. Containing even MORE links to the discography (I'm still trying to figure out how to do this table...I'm thinking hard though >.< It's really late)

Then one more table to contain the actual links. Then with basic PHP/MySQL output, I have my lyrics output script. (After I work out the bugs in the PHP...but this is how I'm thinking of doing it SQL wise)

Does that sound about right (It could work) or am I being ignorant (It won't work, your an idiot)?

Oh yeah, quick question. Normally I use an ID row to keep my tables organized. If I don't use an ID row or set my "name" row as the primary, will it order it alphebetically? That will make life a lot easier...

__________________

[ reply ]