how to save sql string result in a variable ?

Question

 i have a text box from where the id of the user is taken 

i wrote a sql query which return the id passed in text box is a teacher or student 

i want to store the resulted string in a variable

 

eg. if  pass 101 in text box the query gives me a record saying role teacher

this teacher value i want to store in a variable