I am using the following code to query a database and build an HTML table.
<html> <head> <title>SQL Connect</title> </head>
<body>
<?php
/* Connecting, selecting database */
$link = mysql_connect("localhost", "root", "")
or die("Could not connect");
//print "Connected successfully";
mysql_select_db("irvington") or die("Could not select database"); /* Performing SQL query */
$query = "SELECT * FROM staff";
$result = mysql_query($query) or die("Query failed"); /* Printing results in HTML */
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
}
print "</table>\n"; /* Free resultset */
mysql_free_result($result); /* Closing connection */
mysql_close($link);
?></body> </html>
So far so good...
The SQL query returns this: mysql> select * from staff; +----------------+------------------------------+------------------+ | name | email | subject | +----------------+------------------------------+------------------+ | Scott Thompson | [EMAIL PROTECTED] | Volunteer | | <sanitized> | <sanitized> | Computer Science | | Some Teacher | [EMAIL PROTECTED] | some subject | +----------------+------------------------------+------------------+ 3 rows in set (0.00 sec)
mysql>
The above is also essentialy what you see in your browser (sans headers).
So far so good...
What I want (and can't figure out) is how to have each email address have a URL (i.e. mailto:[EMAIL PROTECTED]).
I'm fairly new to PHP, I hope this question made some sense.
Suggestions?
~Scott
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
