Hi Jarow
Welcome to PHP. What you want to do is put the DB field values into an array using mysql_fetch_array() and then just iterate through the array, putting each result into a new para. It would be something like this:
<?php
// Connect to DB etc.
$query = "SELECT institucion, department, department2, address, city, country, postalcode FROM mytable";
$result = mysql_fetch_array($query, MYSQL_NUM);
for ($i=0; $i<count($result); $i++)
{
echo "<p>" . $result[$i] . "</p>";
}
?>
Thus, empty fields would produce nothing at all. Needless to say, there are a multiplicity of ways to skin this particular cat. If you want more info about this code, try these manual pages:
http://de.php.net/manual/en/function.mysql-fetch-array.php
http://de.php.net/manual/en/function.count.php
http://de.php.net/manual/en/control-structures.for.php
You may also find this article page helpful:
http://www.mysql.com/articles/ddws/23.html
HTH
Norm
