Skip to content


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!

Posted in Computers and Technology.


0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.

 


Rss Feed Tweeter button Facebook button Myspace button Linkedin button Youtube button