Fetch row echo as email link

[npereira]

Hi all,

I have a table that contains email addresses. In my PHP file, I want the email to show up as a <a href="mailto🙁email)"> and the link to be "Email", clickable only if the record contains an email address.

Here is what the php script looks like.

$result = mysql_query("SELECT * FROM membres ORDER BY nom ASC",$db);

echo "<table border=1 cellpadding=5 align=center>\n";
echo "<tr><td><h3>Prénom</h3></td><td><h3>Nom</h3></td><td><h3>Adresse</h3></td><td><h3>Téléphone</h3></td><td><h3>Fréquence</h3></td><td><h3>Email</h3></td></tr>\n";

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

    printf("<tr><td nowrap>%s</td><td nowrap>%s</td><td nowrap>%s</td><td nowrap>%s</td><td nowrap>%s</td><td nowrap><a href=\"mailto:%s\">%s</a></td></tr>\n", $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6]);
    }										

    echo "</table>\n";

?>

Thanks in advance for your help.

[DigitalExpl0it]

you need to define the the table you want to get the data from heres a ez way

<?
$result = mysql_query("SELECT * FROM membres ORDER BY nom ASC",$db);

echo "<table border=1 cellpadding=5 align=center>\n";
echo "<tr><td><h3>Prénom</h3></td><td><h3>Nom</h3></td><td><h3>Adresse</h3></td><td><h3>Téléphone</h3></td><td><h3>Fréquence</h3></td><td><h3>Email</h3></td></tr>\n";

while ($myrow = mysql_fetch_row($result)) {
$email = $myrow["email"]; 
        }	
        echo"<a href='mailto:$email'>$email</a>\n";		

?>

something like that

[npereira]

This is not working right!
Now it only echo's the last record of the database and not all of the records.

here is what the code looks like now.

$result = mysql_query("SELECT * FROM membres ORDER BY nom ASC",$db);

echo "<table border=1 cellpadding=5 align=center>\n";
echo "<tr><td><h3>Prénom</h3></td><td><h3>Nom</h3></td><td><h3>Adresse</h3></td><td><h3>Téléphone</h3></td><td><h3>Fréquence</h3></td><td><h3>Email</h3></td></tr>\n";

while ($myrow = mysql_fetch_row($result)) {
$prenom = $myrow["1"];
$nom = $myrow["2"];
$adresse = $myrow["3"];
$telephone = $myrow["4"];
$fréquence = $myrow["5"];
$email = $myrow["6"]; 
        }    

	echo "<tr><td nowrap>$prenom</td><td nowrap>$nom</td><td nowrap>$adresse</td><td nowrap>$telephone</td><td nowrap>$fréquence</td><td nowrap><a href='mailto:$email'>$email</a></td></tr>\n";

echo "</table>\n";

?>

[The_Chancer]

Are the E-Mail addresses verified as OK before they are put in the database ? Otherwise you could be trying to send mail to [e-mail]

But try this:

$result = mysql_query("SELECT * FROM membres ORDER BY nom ASC",$db);

echo "<table border=1 cellpadding=5 align=center>\n";
echo "<tr><td><h3>Prénom</h3></td><td><h3>Nom</h3></td><td><h3>Adresse</h3></td><td><h3>Téléphone</h3></td><td><h3>Fréquence</h3></td><td><h3>Email</h3></td></tr>\n";

while(list($myrow = mysql_fetch_array($result))) {

    print("<tr><td nowrap>$myrow[1]</td><td nowrap>$myrow[2]</td><td nowrap>$myrow[3]</td><td nowrap>$myrow[4]</td><td nowrap>$myrow[5]</td><td nowrap><a href=\"mailto:$myrow[6]\">E-Mail</a></td></tr>\n");
    }										

    echo "</table>\n";

?>

Might now work....

[npereira]

getting an error :

Parse error: parse error, expecting ','' or')'' in /usr/local/psa/home/vhosts/lesailerons.net/httpsdocs/liste-membres/index.php on line 20

the line 20 is ;

while(list($myrow = mysql_fetch_array($result))) {

[npereira]

Ok, I took the (list out and now it works half way.

I also had to change the

<td nowrap><a href=\"mailto:$myrow[6]\">E-Mail</a></td>

to this

<td nowrap><a href=\"mailto:$myrow[6]\">$myrow[6]</a></td>

Now the email link will show up only if there is an email address in the database.

Thanks to all that helped.