Hi,
I use MySQl & php for a small e-mail address book on my site, so the script for searching the address book looks like this:<?php
mysql_connect (localhost, user, pass);
mysql_select_db (my_base);
if ($nam_e == "")
{$nam_e = '%';}
if ($lstnam_e == "")
{$lstnam_e = '%';}
$result = mysql_query ("SELECT * FROM adbook
WHERE name LIKE '$nam_e%'
AND lstname LIKE '$lstnam_e%'
ORDER BY lstname
");
if ($row = mysql_fetch_array($result)) {
do {
print $row["name"];
print (" ");
print $row["lstname"];
print (": ");
print $row["email"];
print ("<p>");
} while($row = mysql_fetch_array($result));
} else {print "No records found!";}
?>
I'd like to display e-mail like a link, and with this code, it's presented as a normal text.
What code should I add?
Thnx in advance.
