1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 7:15 pm May 1, 2026

Forum Moderators: coopster

Message Too Old, No Replies

Pulling an Array of hyperlinks

         

Shaman13

6:57 pm on Jul 15, 2005 (gmt 0)

10+ Year Member



Good Day to All you Fine Folks. I was hoping that someone could give me some direction on how to display the results of my array from my MySQL database as a mailto: hyperlink so the user could click on it to send the person an email.

I want the EMAIL row displayed as a mailto: hyperlink. Any and All suggestions are appreciated! Thanks
Have a Great Day!
Here is what I have for code
-------------------------------------
$result = mysql_query( "SELECT * FROM staff_copy")
or die("SELECT Error: ".mysql_error());
?>
<font face="Times New Roman" size="3">
<?php
print("<TABLE BORDER=1,width=725, body bgcolor=#FFFFFF><TR>");
print("<TH>Staff Number</TH>");
print("<TH>First Name</TH>");
print("<TH>Last Name</TH>");
print("<TH>Email</TH></TR>");
for ($index = 0; $index < 5; $index++)
$j=true;
while ($row = mysql_fetch_row($result))
{
if($j)
$j=false;
else
$j=true;
echo "<tr>";

for ($i=0;$i<mysql_num_fields($result);$i++){
if ($j){
echo "<td bgcolor=\"#CCFF99\">";
}
if (!$j){
echo "<td bgcolor=\"#FFFFCC\">";
}
echo $row[$i];

echo"</td>";
}
}
echo "</table></center>
</div>
";
?>
</center>
<?PHP
while($row=mysql_fetch_array($result)) {
print '<tr><td>'.$row['SNUM'].'</td><td>'.$row['SFNAME'].'</td><td>'.$row['SLNAME'].'</td>
<td>'.$row['EMAIL'].'</td></tr>';
}
?>
</table>

sned

7:06 pm on Jul 15, 2005 (gmt 0)

10+ Year Member



<td>'.$row['EMAIL'].'</td>

Try something like this:

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

-sned

Shaman13

7:15 pm on Jul 15, 2005 (gmt 0)

10+ Year Member



Sned

Thanks for the response. I tried this and several other combinations unsuccessfully. It pulls the info from the table but displays it as just plain text. I have the feeling that I am missing a critical "" or '' someplace, but just can't figure out where. There are a lot of combinations.

Thanks Again!

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

sned

7:19 pm on Jul 15, 2005 (gmt 0)

10+ Year Member



hmm, I'm wondering if its the 'print' at the beginning ... I wonder what would happen if you changed it to a variable, maybe something like $printvar = ....

Then echoed it out ... echo $printvar.

<edit>
after testing it out .. print should work just fine, I don't know why I thought it wouldn't ... maybe I haven't had enough caffiene yet..

</edi>

sned

7:25 pm on Jul 15, 2005 (gmt 0)

10+ Year Member



What does your html source code look like after the script has run? .. specifically the address table ...

Shaman13

7:35 pm on Jul 15, 2005 (gmt 0)

10+ Year Member



Sned
I am not sure I know what you mean. What I posted is what I have got. Thats it. Here is the page with the complete script. It queries the db and fetches the result then renders it into a table with the contents.

Thanks Again!
---------------------------------------
<html>
<head>
<title>A List of Current Staff</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
td,body {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>
</head>
<body bgcolor="#FFFFCC">
<?php
include ('global.php');
error_reporting(E_ALL);
ini_set('display_errors', true);
ini_set('html_errors', false);
?>
<font color="#FF0000"size="4"></font>
<?
$result = mysql_query( "SELECT * FROM staff_copy")
or die("SELECT Error: ".mysql_error());
?>
<font face="Times New Roman" size="3">
<?php
print("<TABLE BORDER=1,width=725, body bgcolor=#FFFFFF><TR>");
print("<TH>Staff Number</TH>");
print("<TH>First Name</TH>");
print("<TH>Last Name</TH>");
print("<TH>Email</TH></TR>");
for ($index = 0; $index < 5; $index++)
$j=true;
while ($row = mysql_fetch_row($result))
{
if($j)
$j=false;
else
$j=true;
echo "<tr>";

for ($i=0;$i<mysql_num_fields($result);$i++){
if ($j){
echo "<td bgcolor=\"#CCFF99\">";
}
if (!$j){
echo "<td bgcolor=\"#FFFFCC\">";
}
echo $row[$i];

echo"</td>";
}
}
echo "</table></center>
</div>
";
?>
</center>
<?PHP
while($row=mysql_fetch_array($result)) {
print '<tr><td>'.$row['SNUM'].'</td><td>'.$row['SFNAME'].'</td><td>'.$row['SLNAME'].'</td>
<td>'.$row['EMAIL'].'</td>td><a href="mailto:'.$row['EMAIL'].'">'.$row['EMAIL'].'</a></td></tr>';
}
?>
</table>
</body>
</html>

jatar_k

7:39 pm on Jul 15, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I think sned meant what the view source in your browser looked like, meaning the script output

Shaman13

7:49 pm on Jul 15, 2005 (gmt 0)

10+ Year Member



Thanks for the clarification jatar k!

Here is the source output!

<html>

<head>

<title>A List of Current Staff</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
td,body {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>

</head>

<body bgcolor="#FFFFCC">


<font color="#FF0000"size="4"></font>

<font face="Times New Roman" size="3">

<TABLE BORDER=1,width=725, body bgcolor=#FFFFFF><TR><TH>Staff Number</TH><TH>First Name</TH><TH>Last Name</TH><TH>Email</TH></TR><tr><td bgcolor="#FFFFCC">1</td><td bgcolor="#FFFFCC">John</td><td bgcolor="#FFFFCC">Tobin, Jr.</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">2</td><td bgcolor="#CCFF99">Elliott</td><td bgcolor="#CCFF99">Berry</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">3</td><td bgcolor="#FFFFCC">Kay</td><td bgcolor="#FFFFCC">Drought</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">4</td><td bgcolor="#CCFF99">Jon</td><td bgcolor="#CCFF99">Baird</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">10</td><td bgcolor="#FFFFCC">Ken</td><td bgcolor="#FFFFCC">Barnes</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">15</td><td bgcolor="#CCFF99">Charles</td><td bgcolor="#CCFF99">Gerhan</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">16</td><td bgcolor="#FFFFCC">Alan</td><td bgcolor="#FFFFCC">Linder</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">17</td><td bgcolor="#CCFF99">Bennett</td><td bgcolor="#CCFF99">Mortell</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">18</td><td bgcolor="#FFFFCC">Karen</td><td bgcolor="#FFFFCC">Rosenberg</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">21</td><td bgcolor="#CCFF99">Judith</td><td bgcolor="#CCFF99">Jones</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">23</td><td bgcolor="#FFFFCC">Laurel</td><td bgcolor="#FFFFCC">O'Connor</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">25</td><td bgcolor="#CCFF99">Velma</td><td bgcolor="#CCFF99">McClure</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">26</td><td bgcolor="#FFFFCC">Cheryl</td><td bgcolor="#FFFFCC">Driscoll</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">27</td><td bgcolor="#CCFF99">Lynne</td><td bgcolor="#CCFF99">Parker</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">29</td><td bgcolor="#FFFFCC">Heather</td><td bgcolor="#FFFFCC">Schulze</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">30</td><td bgcolor="#CCFF99">Robert</td><td bgcolor="#CCFF99">Brazil</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">34</td><td bgcolor="#FFFFCC">Valerie</td><td bgcolor="#FFFFCC">Reed</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">35</td><td bgcolor="#CCFF99">John</td><td bgcolor="#CCFF99">Bomster</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">36</td><td bgcolor="#FFFFCC">Christine</td><td bgcolor="#FFFFCC">Lavallee</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">38</td><td bgcolor="#CCFF99">Mary</td><td bgcolor="#CCFF99">Claassen</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">40</td><td bgcolor="#FFFFCC">Joanne</td><td bgcolor="#FFFFCC">Petito</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">41</td><td bgcolor="#CCFF99">Ruthie</td><td bgcolor="#CCFF99">Cartlidge</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">42</td><td bgcolor="#FFFFCC">Laura</td><td bgcolor="#FFFFCC">Kelly</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">43</td><td bgcolor="#CCFF99">Ruth</td><td bgcolor="#CCFF99">Heintz</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">49</td><td bgcolor="#FFFFCC">Rae Marie</td><td bgcolor="#FFFFCC">Mckay</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">50</td><td bgcolor="#CCFF99">Vickie</td><td bgcolor="#CCFF99">Brooks</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">52</td><td bgcolor="#FFFFCC">Dona</td><td bgcolor="#FFFFCC">Larsen</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">56</td><td bgcolor="#CCFF99">Christine</td><td bgcolor="#CCFF99">Wellington</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">67</td><td bgcolor="#FFFFCC">Sandi</td><td bgcolor="#FFFFCC">Tremblay</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">69</td><td bgcolor="#CCFF99">Randy</td><td bgcolor="#CCFF99">Reis</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">102</td><td bgcolor="#FFFFCC">Robin</td><td bgcolor="#FFFFCC">McCallum</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">103</td><td bgcolor="#CCFF99">Carolyn</td><td bgcolor="#CCFF99">Graham</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">104</td><td bgcolor="#FFFFCC">Karen</td><td bgcolor="#FFFFCC">Leahy</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">107</td><td bgcolor="#CCFF99">Casandra</td><td bgcolor="#CCFF99">Pitney</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">109</td><td bgcolor="#FFFFCC">Margaret</td><td bgcolor="#FFFFCC">McLaughlin</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">113</td><td bgcolor="#CCFF99">Donna</td><td bgcolor="#CCFF99">Giddings</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">117</td><td bgcolor="#FFFFCC">Carl</td><td bgcolor="#FFFFCC">Gabel</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">121</td><td bgcolor="#CCFF99">Sarah</td><td bgcolor="#CCFF99">McCarthy</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">122</td><td bgcolor="#FFFFCC">Susan</td><td bgcolor="#FFFFCC">Guild</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">123</td><td bgcolor="#CCFF99">Rose</td><td bgcolor="#CCFF99">Lamerand</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">126</td><td bgcolor="#FFFFCC">Jessica</td><td bgcolor="#FFFFCC">Durkis</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">128</td><td bgcolor="#CCFF99">Joe</td><td bgcolor="#CCFF99">Webster</td><td bgcolor="#CCFF99"></td><tr><td bgcolor="#FFFFCC">130</td><td bgcolor="#FFFFCC">Cindy</td><td bgcolor="#FFFFCC">Chapman</td><td bgcolor="#FFFFCC"></td><tr><td bgcolor="#CCFF99">200</td><td bgcolor="#CCFF99">Scot</td><td bgcolor="#CCFF99">Jones</td><td bgcolor="#CCFF99">sjones@nhta.com</td></table></center>
</div>
</center>


</table>

</body>

</html>

sned

7:53 pm on Jul 15, 2005 (gmt 0)

10+ Year Member



What happens if you try something like:

<?PHP
while($row=mysql_fetch_array($result)) {
// just making the email link a variable for now
$email_link = '<a href="mailto:"' . $row['EMAIL'] . '">' . $row['EMAIL'] . '</a>';
print '<tr><td>'.$row['SNUM'].'</td><td>'.$row['SFNAME'].'</td><td>'.$row['SLNAME'].'</td>
<td>'.$email_link.'</td></tr>';
}

Shaman13

2:33 pm on Jul 18, 2005 (gmt 0)

10+ Year Member



Sned
Thanks for the help! That did the trick. Jatar_K always appreciative of your help. Have a Great Day!
SJ
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

  1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 7:15 pm May 1, 2026