insert value from mysql column to certain users

Is there a user session that for example if

Gabriel has a sales code of 4 and Josh has one of 3

when either of them log in, the number 开发者_C百科appears as value automatically in a input text field?

Its for a invoice that requires a sales code for each person.

any ideas??

What programming language are you using? Just set the session variable 'sales_code' (queried from the DB) after the user logs in, and display it in the text field when necessary.