make email field hyperlink

[rocketshipwreck]

Hello -

i have a page that displays data from mysql:

<?
mysql_connect("$dbServer","$dbUser","$dbPass") or die("Unable to connect to SQL server");
@mysql_select_db("$dbName") or die("Unable to select database");
$result = mysql_query("select `FirstName`,`LastName`,`Address`,`City`,`State`,`ZIP`,`HomePhone`,`CellPhone`,`WorkPhone`,`Email` from contact ORDER BY `contact`.`LastName` ASC");


?>
<p align="center" class="large">Member Roster</p>
<table border="1" width="100%">
<tr>
<?
while ($field=mysql_fetch_field($result)) {
echo "<th>";
echo "$field->name";
echo "</th>";
}
echo "</tr>";

while ($row = mysql_fetch_row($result)) {

echo "<tr>";

for ($i=0; $i<mysql_num_fields($result); $i++) {

echo "<td>";
echo "$row[$i]";
echo "</td>";
}

echo "</tr>\n";
}

echo "</table>";

?>

it works fine, however I'd like the results in the 'Email' field to be a clickable mailto: link and can't seem to figure out how to get it done.

Any help is greatly appreciated!

[bpat1434]

Well, you could use [man]mysql_fetch_assoc/man which would return an associative array you can loop through. So this:

while ($row = mysql_fetch_row($result)) {

echo "<tr>";

for ($i=0; $i<mysql_num_fields($result); $i++) {

echo "<td>";
echo "$row[$i]";
echo "</td>";
}

echo "</tr>\n";
}

Changes to this:

while($row = mysql_fetch_assoc($result))
{
    echo '<tr>
    <td>' . $row['FirstName'] . '</td>
    <td>' . $row['LastName'] . '</td>
    <td>' . $row['Address'] . '</td>
    <td>' . $row['City'] . '</td>
    <td>' . $row['State'] . '</td>
    <td>' . $row['ZIP'] . '</td>
    <td>' . $row['HomePhone'] . '</td>
    <td>' . $row['CellPhone'] . '</td>
    <td>' . $row['WorkPhone'] . '</td>
    <td><a href="mailto:' . $row['Email'] . '">' . $row['Email'] . '</a></td>
</tr>';
}

Hope that helps.

[rocketshipwreck]

Thanks - that works! I was trying to make it work with an if then type operation but couldn't get it

Thanks again,
rocketshipwreck

[bradgrafelman]

Don't forget to mark this thread resolved.

[bpat1434]

I guess you really could get it to work with an if() else() thing, but it would make it look really ugly, and not as easily maintainable. For example (code cleanup was mine):

<?php
	mysql_connect($dbServer,$dbUser,$dbPass) or die("Unable to connect to SQL server");
	@mysql_select_db($dbName) or die("Unable to select database");
	$result = mysql_query("select `FirstName`,`LastName`,`Address`,`City`,`State`,`ZIP`,`HomePhone`,`CellPhone`,`WorkPhone`,`Email` from contact ORDER BY `contact`.`LastName` ASC");


?>
<p align="center" class="large">Member Roster</p>
<table border="1" width="100%">
<tr>
<?php
	$i=0;
	$fields = array();

while ($field=mysql_fetch_field($result)) {
	$fields[$i] = $field->name;
	echo "<th>" . $field->name . "</th>";
	$i++;
}
echo "</tr>";

while ($row = mysql_fetch_row($result)) {
	echo "<tr>";

	for ($i=0; $i<mysql_num_fields($result); $i++) {
		echo "<td>";

		if($fields[$i] == 'Email'){
			echo '<a href="mailto:' . $row[$i] . '">' . $row[$i] . '</a>';
		}
		else{
			echo $row[$i];
		}

		echo "</td>";
	}

	echo "</tr>\n";
}

?>
</table>