MySQL Forums
Forum List  »  PHP

noob qestion
Posted by: fieryphoenix79
Date: January 13, 2006 02:37AM

i have this code and i would like the email output to be a href link but i dont know how to do it in php can someone show me? Note this will put the email($r->email) out just not in a link.
BTW: i tried <a href = "echo "<td valign='top' align='center'>$r->email</td></p>";"></a> and it stopped the email from showing in the table.

CODE:

case "xxx":
// email vars
$email = mysql_query("SELECT * FROM users WHERE username = 'xxx'");
?>
<div class="itemHead"><b>xxx</b></div>
<br><br>
<table border='1'>
<tr>
<td valign='top' align='center'><i><b><font size='2'>Name:</font></b></i></td>
<td valign='top' align='center'><i><b><font size='2'>Occupation:</font></b></i></td>
<td valign='top' align='center'><i><b><font size='2'>Email:</font></b></i></td>
</tr>
<tr>
<td valign='top' align='center'>
<p align='center'>Giacomo </td>
<td valign='top' align='center'>Founder/Coder </td>
<?php

while ($r = mysql_fetch_object($email)) {
echo "<td valign='top' align='center'>$r->email</td></p>";
}
mysql_free_result($email);

?>
</p></tr>



Edited 2 time(s). Last edit at 01/13/2006 02:43AM by fieryphoenix79.

Options: ReplyQuote


Subject
Written By
Posted
noob qestion
January 13, 2006 02:37AM
January 13, 2006 12:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.