5

Spent two hours looking all over my code with so many debuggers I was about to crap and BOOM found you can't use "dec" for a table or string name in PHP. Just typing December would have saved me hours. Not sure why but put ticks around it and everything was fine. I put this one on htmltypos.com so others can figure it out. May be `dec` is shorthand for dechex....?

Comments
  • 0
  • 1
    And tics is one way to escape a table name so it does not clash with reserved words i guess.

    In mssql you use " " or [ ] to escape table or fieldnames
  • 0
    Use ` to escape table and column names in MySQL: SELECT `dec` FROM `drop`
Add Comment