2010-04-23, 03:47
I'd like to change a few things in HTTP-R for my own personal needs but I'm having a difficult time with sqlite and php syntax. I would like to create a string similar to this: "E:\Movies\filename-fanart.jpg"
here is what I think should be done, but I can't write it correctly
I don't know if I should use LEFT or Right to remove the filename suffix(.mkv .avi etc). this is confusing maybe but some help would be great!
here is what I think should be done, but I can't write it correctly
Code:
SELECT strPath FROM path WHERE (strContent = 'movies'), LEFT(strFilename)-4 FROM files, || '-fanart.jpg' WHERE idFile.file=idfile.movie
I don't know if I should use LEFT or Right to remove the filename suffix(.mkv .avi etc). this is confusing maybe but some help would be great!