please help me..urgent! send mail problem

[eluser]miss_amylee[/eluser]
thx a lot.. i want to make user greetings in this mail.. let say

Hello {amylee};

{message body}

etc.

{amylee} is dynamically from database which means will have queue of name. dis name is not available in

$sql = "SELECT * FROM mail WHERE mid = 1001 LIMIT 1";.. i need to get from other table.. what i am confuse here, should i query to get list of name in same page here? and make pre-define template in my view file for example:

template_a.php

Code:

<p> Dear &lt;?php echo $name ;?&gt;

</p>

<p> &lt;?php echo $msg ;?&gt;