For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > March 2004 > An if-statement in a "while(list("









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author An if-statement in a "while(list("
Henning Olsen

2004-03-26, 11:12 pm

Hello

I have a search on my page, which presents all the adresses one after all.
I would like to present a graphic icon representing the mailaddress, but
only when ther IS a mailaddress. Not everyone has a mail address.
But I cant put an if-statement in the "while(list(..."
Any suggestione to me on showing a graphic with a link when $mail is
different from null?

Henning

Code strip:


$searchquery = "SELECT * FROM kontakt WHERE MATCH (navn, telefon, mobil,
kommentar) AGAINST ('$search') order by navn";
$searchresult = mysql_query($searchquery);
$num = mysql_num_rows ($searchresult);
//Hvis der er fundet et resultat:
if ($num > 0) {
while(list($id, $navn, $telefon, $mobil, $adresse, $postnummer, $bynavn,
$kommentar, $mail) =
mysql_fetch_row ($searchresult))
print("<p><a href='kontakt/kontakt_edit.php?id=$id'>$navn</a><br>
<small><A HREF='mailto:$mail'>$mail</a></small><br>
Telefon: $telefon<br>
Mobil: $mobil<br>
Adresse: $adresse, $postnummer $bynavn<br>
<small>$kommentar</small>\n");
}
else
{
echo '<p>Der blev ikke fundet noget, og jeg HAR kigget godt efter!<p>';
}
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com