All: I am new to PHP and was hoping for some input to what is probably an 'easy' question. The following SQL statement returns 1 row: $sql = "SELECT id, real_name FROM authorization WHERE username='$username' and password='$password'"; All I want to do is assign the results of the field real_name to a variable called $salesperson, but I cannot seem to get it to work. Thanks inadvance for your help, Randy Rankin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]