Mail links!

[ee-ore]

Hi im fairly new to PHP and just playing atm..

I have a table of members of a group atm and all have an e-mail address.

How do i pick that e-mail address out of the database and use it for the mailto link?

as in what do i put here >> <a href="mailto: ???">Mail Me</a>

[mattw]

Well, assuming that you are using mySQL as a database, something like this:

$query="SELECT email FROM members WHERE name="Joe Smoe";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
echo "<a href=\"mailto: $row['email']\">Mail Me</a>\n";

Of course you would need to modify that to suit your needs...

Matt Wade
http://codewalkers.com

[ee-ore]

Thats great works a treat..now going one step further..appending a subject to the message..

I know in normal HTML you simply add

?Subject=

on the end of the mail address..similar here?

echo "<a href=\"mailto: $row['email']?Subject=lardelardelar\">Mail Me</a>\n";

Something like that?

Ee-Ore

[mattw]

Yep, that should would fine!

Matt Wade
codewalkers.com