[Resolved] Feasible before the long code process begins

[Kyrst]

artist
art_id
art_name
art_count

album
alb_id
art_id
alb_name
alb_year
alb_ima

band
band_id
art_id

tracks
track_id
alb_id
track_name
track_writer
track_lyric

Will probably use navigation either sorting by artist name (which is where I am primarily leading due to this being a personal use library), album name or track name (will be in the include toc.php part of the my actual coding). I am wondering if in theory this will work for what I am trying to do. This is for a personal library.

Say it was accessed via an artist search.

artist.php
artist names based on band id=art id (band, art)
names clickable leading to artistdetails.php

artistdetails.php
Artist Name

Image ||| Album Name
Album Year
Artist Name
Track Name
Lyrics <lyrics.php>

---

Image ||| Album Name
Album Year
Artist Name
Track Name
Lyrics <lyrics.php>

lyrics.php
will pull up all lyrics to an album based on the track_id=alb_id (track, alb)

Album Name

             	TracK Name
             	Track Writer
             	Track Lyric

---

TracK Name
Track Writer
Track Lyric

Am I looking at this from the right angle before I actually start in all this coding?

[ahundiak]

Keep in mind that some albums have multiple artists. And some artists have belonged to more than one band.

[Kyrst]

How would I manage keeping those seperated.. via seperate entries in the band id, art id?

[Kyrst]

At least i have the notion it is feasible once I figure out how to keep the multiple artist on multiple albums in multpiple bands thing. I kind of think that can be worked with via the id's associated though.

So far the first idea is working as the artist.php will pull up. Will post questions as I have them or need them in the future.