Hi. I have a problem with my tab/lyric site, I need to create an artist
page, where users can view all lyrics/tabs by a certain artist.
Now because im likely to get guitar/drum/bass tabs / lyrics for the same
song, I want to have a table with links as follows (e.g):

Blink 182
---------

Whats my age again?                Guitar    Bass    Drum    Lyrics    Buy
at Amazon.
Dammit                                    Guitar    Bass    Drum    Lyrics
Buy at Amazon.
MnMs                                     Guitar    Bass    Drum    Lyrics
Buy at Amazon.

Now I know this would be simpler if I had them in different tables, but I
have my reasons why I dont.
Here is the setup of the table for storing tabs/lyrics..

CREATE TABLE `resources` (
`id` INT NOT NULL AUTO_INCREMENT,
`type` TEXT NOT NULL,
`title` VARCHAR(100) NOT NULL,
`content` TEXT NOT NULL,
`user_id` INT NOT NULL,
`rating` INT DEFAULT '5' NOT NULL,
`views` INT DEFAULT '0' NOT NULL,
`date` TIMESTAMP NOT NULL,
`artist_id` TEXT,
`amazon` TEXT,
INDEX (`id`),
UNIQUE (`id`)
);

I was thinking I could extract data and shove it into a temporary table, but
that just creates other problems, I think. Anyone got any suggestions?
Please?



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to