How would I do this?
| From: | Tony Harrison | Date: | Mon, 29 Jul 2002 17:21:39 +0000 |
| Subject: | How would I do this? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-110218@lists.php.net to get a copy of this message | ||
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?