[PHP] Adding a URL

[Scott Thompson]

Hi,

I am using the following code to query a database and build an HTML table.


 
  SQL Connect
 
 
  
/* Performing SQL query */
$query = "SELECT * FROM staff";
$result = mysql_query($query) or die("Query failed");
/* Printing results in HTML */
print "\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t\n";
foreach ($line as $col_value) {
print "\t\t$col_value\n";
}
print "\t\n";
}
print "\n";
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($link);
  ?>
 

So far so good...

The SQL query returns this:
mysql> select * from staff;
++--+--+
| name   | email| subject      |
++--+--+
| Scott Thompson | [EMAIL PROTECTED] | Volunteer|
| |   | 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

Re: [PHP] Adding a URL

[Scott Thompson]

Thank you, your suggestions worked perfectly!

~Scott

Don Read wrote:
On 30-Mar-2003 Scott Thompson wrote:

Hi,

I am using the following code to query a database and build an HTML
table.




/* Printing results in HTML */
print "\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {


$line['email'] =
 '' .$line['email'].'';

print "\t\n";
foreach ($line as $col_value) {
 print "\t\t$col_value\n";
}
print "\t\n";


// how about this ?

 echo "\n", implode('', $line), ''; 


}
print "\n";


 


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?



Regards,


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php