Hello all, [~~I guess I could do something like MySQL>select FROM "Songs" where "artists" contains $currentArtist~~]
I have a sampling section on a site that I am working on and am trying to find out how to display a table of the artists featured in that song. The sample section works as follows: Go to the samples page and choose an album to sample. Returns the list of song names that result from the album you chose click on one of the song names to open a new window with the shockwave file that streams the song. The client has asked me to add the (one or many) artists featured in that song in the window that loads up. I am not sure how to set this up. It would be a many to many relationship I think... <Artists Table> (one given artist could be featured on many different songs) [many] to <Songs Table> (one given song could have many featured artists) [many] My first thout of how to set this up is to just enter comma delimited data into a field in the song database called, "artists". But when I query it I don't know how I could make that work. I guess I could do something like MySQL>select FROM "Songs" where "artists" contains $currentArtist< Would that work? Is there a such thing as "contains". (kinda new to SQL). Thanks for your help, Robbie --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
