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.


snip

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


$line['email'] =
 'A HREF=mailto:' .$line['email'] .'' .$line['email'].'/A';

print \ttr\n;
foreach ($line as $col_value) {
 print \t\ttd$col_value/td\n;
}
print \t/tr\n;


// how about this ?

 echo \ntrtd, implode('/tdtd', $line), '/td/tr'; 


}
print /table\n;


snip 


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

[PHP] Adding a URL

[Scott Thompson]

Hi,

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

html
 head
  titleSQL 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 \ttr\n;
foreach ($line as $col_value) {
print \t\ttd$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