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