[RESOLVED] file paths in mysql

[djwinder]

hi everyone

i have posted onto the mysql forums with no responce and hoped someone here could help me out. i have noticed that mysql strips the '\' out of my file paths when i insert the path into mysql there must be a way to get round this, can someone please tell me how.

thanks

[devinemke]

post the code you are using to do the insert

[djwinder]

thats the sql i was using havent used it as part of a php script yet because i want this sql to work before i tried writing a script.

update settings set masthead = "c:\web\root\images\dhstmast.jpeg" where clubid = 1

thanks for the help

[devinemke]

UPDATE settings SET masthead = 'c:\\web\\root\\images\\dhstmast.jpeg' where clubid = 1

[djwinder]

that code has inserted the following line 'c:\web\root\images\dhstmast.jpeg' in the database. I was expecting the data to be 'c:\web\root\images\dhstmast.jpeg' considering it seems to strip one '\' when only one is used. with the '\' windows does not recognise the file path.

any idea what the solution might be to get it to insert the line as 'c:\web\root\images\dhstmast.jpeg'

[Roger_Ramjet]

The problem boils down to the fact that \ is the sql escape character. To overcome this problem the simplest way is just to use mysql real escape string() on the data before inserting it.

[djwinder]

thanks for the help another problem sorted 🙂