I know how to create a table but is there a better way than repeating the same user location (Country,State, City) which are common for some users in the User table.

Problem of indexing Country, State , City table.
Instead of entering repeated user location for several users who share the same location I am planning to normalize by giving locationID from Locations table to each user in the User table so that I don’t have to enter Country, State, City repeatedly in the User table so I save disk space. (USA, CT, Woodhaven )
After several users say 12th users may enter USA,NY, Albany...

I have following code snippet to implement a multilingual website.
Idea is to, depending on user's language i need to translate word "Man" to "Hombre"

My Question: Will it be valid to use $user_language instead of hard coded column name "Spanish" here.

code:
...