Hi, It's my first post here so excuse me if I'm a little vague.
For this example I have two tables; 'songs' that contains an ID of the track and name (and other info we don't need to know) and 'setlists' which is a link table for other tables, which for this purpose don't matter. 'Setlists' has an ID field and a field which holds a comma-delimited array of IDs which I want to refer to the 'songs' table. SONGS +------------+----------------------------+ ID Song name +------------+-----------------------------+ 1 Song title SETLISTS +------------+------------------------------+ ID ID Array +------------+------------------------------+ 1 1,2,3,4,5,6,7,8,23,56 Is there a way of structuring a sql SELECT to recursively bring out the song names from the setlist array? To add to the example; We might have a table for 'albums' or 'gigs' and we refer to the setlists to see which songs were used either for the running order of the album or for the songs played at a particular gig. This is the only problem I have with the queries so far so any help would be appreciated! Cheers, Dan Donald reach multimedia unit 12 honley business centre new mill rd holmfirth huddersfield west yorkshire hd9 6qb Tel: 0151 291 0758 Fax: 01484 663359 Email: [EMAIL PROTECTED] http://www.reachmultimedia.com --------------------------------------------------------------------- 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
