[SOLVED] ID or id !!!

[npsari]

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

[~n[EO]n~]

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 ?

[npsari]

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 

[~n[EO]n~]

It won't be disabled. Even this site (SMF) members database use capital letter for storing member id

ID_MEMBER

[npsari]

that is good news then

thanks for the reply