$query="SELECT firstname, surname, office, town FROM supporters WHERE publish='yes' AND approve='yes' ORDER BY surname";
$result= mysql_query($query) or die ("Couldn't execute query");
echo "

“;
while ($row=mysql_fetch_array($result))
{
extract($row);
if (empty($office))
{
echo “
1. “.$firstname.” “.$surname.”, “.$town.”

“;
} else {
echo “

2. “.$firstname.” “.$surname.” (”.$office.”), “.$town.”

“;
}
}
echo “

“;

$query=”SELECT * FROM supporters WHERE publish NOT LIKE ‘yes’ AND approve=’yes’ ORDER BY surname”;
$result= mysql_query($query) or die (”Couldn’t execute query”);
$rows=mysql_num_rows($result);
echo “

In addition, “.$rows.” people have also signed but would prefer to be anonymous.

“;
?>
Sign up here if you would like to have your name added!