$sentence = "select * from subscribers ";
$sentence .= "where confidential <> 'Y' ";
$sentence .= "and listname = 'arberesh' ";
$sentence .= "order by lastname, firstname ";
$result = mysql_db_query("umd", $sentence);
$kount = 0;
while ($row = mysql_fetch_array($result)):
$kount = $kount + 1;
echo "\n";
echo "";
echo $kount . ". ";
$name = $row["firstname"] . " " . $row["lastname"];
echo $name;
$email_addr = $row["email"];
echo " $email_addr\n";
$location = $row["location"];
if ($location <> "") {
echo "$location\n";
}
$villages = $row["villages"];
if ($villages <> "") {
if ($liston == "") {
echo "
\n";
$liston = "1";
}
echo "- Villages: $villages\n";
}
$surnames = $row["surnames"];
if ($surnames <> "") {
if ($liston == "") {
echo "
\n";
$liston = "1";
}
echo "- Surnames: $surnames\n";
}
$comments = $row["comments"];
if ($comments <> "") {
if ($liston == "") {
echo "
\n";
$liston = "1";
}
echo "- Comments: $comments\n";
}
if ($liston <> "") {
echo "
\n\n";
}
endwhile;
?>