Make emails produced by query active links

Question

$result = mysql_query("SELECT * FROM my_table ORDER BY company_name");

echo "<center><table border='1px' style='font-size: 12px;'>
<center><tr>
<th>Contact Email</th>
</tr></center>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['contact_email'] . "</td>";
  echo "</tr>";
  }
echo "</table></center>";

I need for the email addresses to be printed out as links so that users can just click on the email address to start an email. Is this possible?

[**Please, don't use `mysql_*` functions in new code**](http://bit.ly/phpmsql). They are no longer maintained [and are officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). See the [**red box**](http://j.mp/Te9zIL)? Learn about [*prepared statements*](http://j.mp/T9hLWi) instead, and use [PDO](http://php.net/pdo) or [MySQLi](http://php.net/mysqli) - [this article](http://j.mp/QEx8IB) will help you decide which. If you choose PDO, [here is a good tutorial](http://j.mp/PoWehJ). — tereško, Feb 14 '13 at 23:15

score 2 · Answer 1 · edited May 23 '17 at 11:56

2

you can do this by

echo  "<td><a href='mailto:".$row['contact_email']."'>".$row['contact_email'] ."</a></td>";

Note

The entire ext/mysql PHP extension, which provides all functions named with the prefix mysql_, is officially deprecated as of PHP v5.5.0 and will be removed in the future. So use either PDO or MySQLi

Good read

edited May 23 '17 at 11:56

Community

1
1

answered Feb 14 '13 at 16:08

NullPoiиteя

56,591
22
125
143

1

That worked perfectly. I tried something similar but must not have had the syntax right. Thank you for your help! – Ryan Livingston Feb 14 '13 at 16:12

score 2 · Answer 2 · answered Feb 14 '13 at 16:09

2

Nothing magical about it...

echo <<< EOL
<td><a href="mailto:{$row['contact_email']}">{$row['contact_email']}</a></td>

EOL;

answered Feb 14 '13 at 16:09

Marc B

356,200
43
426
500

score 1 · Answer 3 · edited Feb 14 '13 at 16:11

1

Just do:

echo '<td><a href="mailto:' . $row['contact_email'] . '">' . $row['contact_email'] . '</a></td>';

edited Feb 14 '13 at 16:11

gen_Eric

223,194
41
299
337

answered Feb 14 '13 at 16:09

Develoger

3,950
2
24
38

1

Be careful of your quotes. I fixed it for you :) – gen_Eric Feb 14 '13 at 16:11

score 1 · Answer 4 · edited Feb 14 '13 at 16:12

1

This is an email link:

<a href="mailto:someone@example.com?Subject=Hello%20again">

edited Feb 14 '13 at 16:12

gen_Eric

223,194
41
299
337

answered Feb 14 '13 at 16:09

elrado

4,960
1
17
15

score 1 · Answer 5 · answered Feb 14 '13 at 16:09

1

That would be something like:

echo "<td><a href='mailto:" . htmlspecialchars($row['contact_email']) . "'>" . htmlspecialchars($row['contact_email']) . "</a></td>";

answered Feb 14 '13 at 16:09

jeroen

91,079
21
114
132

Make emails produced by query active links

5 Answers5