When I run the sql query below I get an error that says "Operand should contain 1 column(s)" It is probably something simple I'm new to trying to write two statements together. Any thoughts?
$data = mysql_query("SELECT username, first_name, last_name, middle_name FROM users WHERE username IN (SELECT * FROM users WHERE state_id=".$session_state_id.") ORDER BY ".$sorter." ASC")