ToonMariner Posted October 16, 2007 Share Posted October 16, 2007 Hi guys n gals - a tuff query I am struggling with... I have a table of media (video and audio) these play in a flash player. The videos are fine but the audio have images associated with them... What i need is to select media from this database and when the record is an audio file select an image to go with it. the record has a field `imgs` which contains a , delimted string of numbers - these represent the id of an image in another table. I just want to select a random image from that string of ids or just the 1st id in the string and i'd LOVE to do it in one query! [pre] media table med_id ... type imgs 1 audio 1,2,4,5 2 video 3 video 4 audio 7,8,9 images table img_id path 1 /pics/abc.gif 2 /pics/def.jpg 3 /pics/ghi.gif ....... [/pre] Hope I have explained enough for you to understand - if not tell me off and I'll try again... Link to comment https://forums.phpfreaks.com/topic/73453-tough-query/ Share on other sites More sharing options...
fenway Posted October 16, 2007 Share Posted October 16, 2007 Delimited number of strings? that's your problem -- you need to normalize this table. Link to comment https://forums.phpfreaks.com/topic/73453-tough-query/#findComment-370665 Share on other sites More sharing options...
ToonMariner Posted October 16, 2007 Author Share Posted October 16, 2007 better toi have a field in the images table that links to the media id and not having the imgs fiels rather than my current set up? Link to comment https://forums.phpfreaks.com/topic/73453-tough-query/#findComment-370695 Share on other sites More sharing options...
lemke411 Posted October 16, 2007 Share Posted October 16, 2007 I guess it depends on how you have every thing set up. If you have a set amount of images (img1 - img7) and the audio records relate and reuse the images. Like audio1 uses img1, img3, and img4 and audio2 uses img2, img5, and img1 then I would create another table that holds that relation between the two tables. Link to comment https://forums.phpfreaks.com/topic/73453-tough-query/#findComment-370831 Share on other sites More sharing options...
fenway Posted October 16, 2007 Share Posted October 16, 2007 I guess it depends on how you have every thing set up. If you have a set amount of images (img1 - img7) and the audio records relate and reuse the images. Like audio1 uses img1, img3, and img4 and audio2 uses img2, img5, and img1 then I would create another table that holds that relation between the two tables. Doesn't matter how it's set up -- always use a many-to-many table for stuff like this. Link to comment https://forums.phpfreaks.com/topic/73453-tough-query/#findComment-370836 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.