Hi all,
A client's site is moving from Windows to Linux hosting. It's creating a pain!
The latest problem is that the site's database contains about 3000 records for images eg id=1, src=football.jpg
Because the src field was client entered the case varies, e.g. footBall1.jpg
This wasn't a problem on windows, but on linux it obviously now is: many of the files in the database don't match the files on the server for case.
So, I think I can get the file names of all 3000 images on the server converted to lowercase, meaning I have to do the same for the src fields in the database.
Any idea how I can do this quickly?
I'm guessing I might have to write a script to:
SELECT all from images
Look at first record, convert src to lowercase
Update first record in database,
Look at second record.
Etc.
Or is there an easier way?
