London ConservativesCouncillors in - Links on the name of the Councillor point to borough or personal web pages.
$plist[partyName] members ($numC)"; ?>
"; $selector=pcolumn($boroughID,$manor, $plist[partyID],$plist[partyName],$rType,$nameSearch); $selector = str_replace("name LIKE", "candidateName LIKE",$selector); $Query ="select * from votes LEFT JOIN manor USING (manorID) $extab LEFT JOIN party ON (votes.partyID=party.partyID) WHERE ( $selector ) ORDER BY voteDate DESC, manor, vote DESC;"; // echo "$Query\n"; $vsums = mysql_query($Query); while ($row = mysql_fetch_array($vsums)) { if($row[voteDate]!=$lastdate) { if(isset($lastdate)) echo "\n"; echo ""; $lastdate=$row[voteDate]; } else { echo ""; } if($row[manor]!=$lastmanor) { echo ""; $lastmanor=$row[manor]; } else { echo ""; } echo ""; echo ""; echo "\n"; } ?>
$row[voteDate]
 $row[manor] $row[candidateName]$row[candidateDescription]$row[vote]