Create a mailto-link

[elangsru]

Hello, hoper someone can help me

I have two tables (news and user) where the field NAME is common in both. In the user-table I also have the field EMAIL.

I want to echo NAME from the news-table and create a corresponding mailto-link by using the email-address in the user-table.

I'm sure its really simple, but I'm a beginner at this.

(I use Dreamweaver 8.0 at this...)

[nemonoman]

assuming you have the name you want in a PHP variable name:

$result=mysql_query("
SELECT CONCAT('<a href=mailto:',EMAIL,'>',NAME,'</a>')
FROM user
WHERE NAME='$name'
");
$row=mysql_fetch_array($result);
echo "$row[0]";