# SQL will only submit with \`backticks\` around table names. Why?!

**URL:** <https://forum.kirupa.com/t/sql-will-only-submit-with-backticks-around-table-names-why/284320>\
**Category:** Uncategorized\
**Created:** [March 18, 2009, 12:34am UTC](https://forum.kirupa.com/t/sql-will-only-submit-with-backticks-around-table-names-why/284320 "2009-03-18T00:34:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![onion](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/onion/32/3349_2.png) [@onion](https://forum.kirupa.com/u/onion)\
**Post date:** [March 18, 2009, 12:34am UTC](https://forum.kirupa.com/t/sql-will-only-submit-with-backticks-around-table-names-why/284320/1 "2009-03-18T00:34:14Z")

</div>

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! 😛