npsari Posted November 18, 2007 Share Posted November 18, 2007 In my mySQL table, i put created primary key as ID is it a problem that it is capital letters, should i have made it id? if yes, why? Because now when someone tries to see a topic for example, he types www.example.com/topics.php?ID=3 Will capital letters be disabled one day in browsers!!!, that would be a disaster, please help with some info Quote Link to comment Share on other sites More sharing options...
~n[EO]n~ Posted November 18, 2007 Share Posted November 18, 2007 Variables are case sensitive in PHP. e.g $id and $ID are different. In MySQL you can keep any name you want but using related name will be good like user_id if you have only 1 id in that table and ID_ATTACH ID_THUMB ID_MSG ID_MEMBER if you have multiple ID Will capital letters be disabled one day in browsers!!!, that would be a disaster, please help with some info Any reason to disable capital letters ? Quote Link to comment Share on other sites More sharing options...
npsari Posted November 18, 2007 Author Share Posted November 18, 2007 ohh i see hmm, no reason i guess but i am just worried cus iam sure you know how hard it is to change the id to ID all my site is set up to ID now And i was thinking, what if... capital letters where disabled for mySQL tables Quote Link to comment Share on other sites More sharing options...
~n[EO]n~ Posted November 18, 2007 Share Posted November 18, 2007 It won't be disabled. Even this site (SMF) members database use capital letter for storing member id ID_MEMBER Quote Link to comment Share on other sites More sharing options...
npsari Posted November 18, 2007 Author Share Posted November 18, 2007 that is good news then thanks for the reply Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.