$query = 'SELECT account_tag FROM sinjar_account_type_lookup AS satp JOIN sinjar_account_type AS sat ON satp.account_type=sat.account_type WHERE sat.uid = $uid'; $row = mysql_query($query) or die(mysql_error()); list($tag) = mysql_fetch_row($row);