MySQL TV Show season locations
#1
Question 
Hi

I was wondering if any one could help me write a MySql query to return all the Shows and their individual season locations .

I just cant seem to get it right.

This is what I am trying to get from the MySql query

Image


Thank you for your time

Edit

Ok I got it right may be this will help some one else.

Code:
SELECT tvshow.idShow,tvshow.c00 as 'ShowName',episode.c12 as 'Season',episode.c18 as 'Path'
FROM myvideos75.episode
join tvshow on tvshow.idShow = episode.idShow
group by episode .idShow,episode.c12


The only problem I then had was that Path returns some thing like this

"smb://10.0.0.3/tv/2 Broke Girls/Season1/2 Broke Girls.S01E01.Pilot.avi"

I wrote a simple function to change it to this "\\10.0.0.3\tv\2 Broke Girls\Season1\"

Let me know if you would like the function.
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL TV Show season locations1