MySQL is CaseSensitive!

After at least 2 more hours wasted trying to figure out what the problem is with the movies page, I was able to ascertain that… I had named the tables in the DB the correct way. That is capitalize the first letter in each word.

Of course I didn’t realize this until 17 or so iterations of the same 12 lines of code where I manage to call the DB and it automagically does its thing, and then close it down. Somewhere in there I received multiple “undefined index” notices each time I would try something different. I had noticed about an hour earlier that the case was different in my code vs the DB. I thought to myself “why would it be case-sensitive??”

For future reference to anyone that codes… pay attention to your CamelCase!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.