First, the background, I'm doing an RPG, when you sign up, your class you chose is inserted along with your record, into the database, each class has a number. What I need is code that would allow me to take that number, write it as a variable, then do a few if statements, to eventually lead up to the displaying of the class as an echo. What I don't know how to do, is get the results of a MySQL query to be stored as a variable ($class) (none the less, how would I search a given table for their username / then find their class) I'm very new at PHP coding, so the more explanation the better :-) Thanks in advance, and sorry if its already been posted somewhere.