2013-09-25, 21:12
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
Thank you for your time
Edit
Ok I got it right may be this will help some one else.
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.
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
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.