[Resolvido] variavel passa query não o resultado

boas galera.

problema:

• esta array vem de um formulário:

$username = $_POST['username'];

• com ela, faço consulta no banco de dados para me dar os dados do utilizador:

$name = "SELECT adm01_users.name FROM adm01_users WHERE username = '$username' ";

• depois coloco a variável para o resultado ser mostrado no envio de email:

$mail->MsgHTML("Your Account Settings:<br> <br>Name: '$name'");

Acontece, que o a variavel passa, é a query mesmo:

Your Account Settings:

Name: SELECT adm01_users.name FROM adm01_users WHERE username = 'teste1'

o código completo:

<?php require_once('Connections/recipt.php'); ?>
<?php

$username = $_POST['username'];

$date = date("y-m-d");

$name = "SELECT adm01_users.name FROM adm01_users WHERE username = '$username' ";

include("PHPMailer/class.phpmailer.php");
include("PHPMailer/class.smtp.php");

$mail = new PHPMailer();

//$body = $mail->getFile('');
//$body = eregi_replace("[\]",'',$body);

$mail->IsSMTP();
$mail->SMTPAuth = true;
$mail->SMTPSecure = "***";
$mail->Host = "***.***.***";
$mail->Port = ***;

$mail->Username = "*******@***.***";
$mail->Password = "*****";

$mail->From = "*******@***.***";
$mail->FromName = "*****";
$mail->Subject = "Your updated Account Settings in $date";
$mail->AltBody = "";

$mail->WordWrap = 50; // set word wrap

$mail->MsgHTML("Your Account Settings:<br> <br>'$user_data'");

$mail->AddReplyTo("*******@***.***","***");

//$mail->AddAttachment("/path/to/file.zip");
//$mail->AddAttachment("/path/to/image.jpg", "new.jpg");

$mail->AddAddress("*******@***.***","*****");

$mail->IsHTML(true);

if(!$mail->Send()) {
echo "Mailer Error: " . $mail->ErrorInfo;
} else {

 echo '<meta HTTP-EQUIV="Refresh" CONTENT="0; URL=user_update4.php">';
}
?>

alguma luz? :huh: