Hi. I'm having problems with a field in mysql. The name of the field contains a space "members 00\01". How do I get around this problem when I write SQL?
put the field in single quotes and don't forget to addslashes() unless it is done for you by "magic_quotes_gpc"
I've wrote this directly in phpmyadmin but it didn't work: UPDATE user SET 'members 00/01' = 'ok' I've also tried with brackets, but no luck there neither. ('members 00/01' is the right name for my field and not 'members 00\01' as i wrote first..)