I have been working on a pho project, it’s all going fine and I’m creating lots of very useful functions that submit SQL. They all work fine.
Then suddenly I create a new table and write a fnction to submit SQL to it. I copy an existing function and change the tablename and a couple of field names.
It doesn’t work.
I look at it for hours and try every possible combination to find out why it won’t work, the tablename is correct, the field names are correct. I simplify my SQLdown to “SELECT * FROM character”, and it doesnt work. But if I replace “Character” with “News” it works fine.
So I go to phpmyadmin and submit the SQL there. My SQL throws an error. But I notice that the default text in the SQL box has backticks aroudn the table name. I try adding backticks to my tablename and it works!!!
Can anyone tell me why backticks make this one SQL work, but none of the rest of the ones I have created do?
Thanks. This is driving me mad! 
