An if-statement in a "while(list("

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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>';
}

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux