MJ12

You'd bind the output of the SQL statement to a variable and then echo it normally, I'd imagine. I haven't written PHP in many years, so you'd probably echo each column out as echo $row['column_name']; or something like that.

You'd want to use a prepared statement SELECT currency, rank FROM users WHERE name = ? LIMIT 1; where ? is replaced by the username as a bound variable. An example of this is shown here: https://www.w3schools.com/php/php_mysql_prepared_statements.asp.

What language / framework are you using?