Update analytics.php

[clinton/MarylandElectronicPetitionSignature.git] / admin / search.php

diff --git a/admin/search.php b/admin/search.php
index 6734ce9..0f17dbb 100644 (file)
--- a/admin/search.php
+++ b/admin/search.php
@@ -10,12 +10,14 @@ if ($_POST['LASTNAME']){
   $LASTNAME=$_POST['LASTNAME'];
 }
 if($LASTNAME != ''){
-  $q = "select * from VoterList where LASTNAME like '%$LASTNAME%' ";
+  echo "<ol>";
+  $q = "select * from VoterList2 where LASTNAME like '%$LASTNAME%' limit 0, 5000 ";
   echo "$q";
   $r = $petition->query($q);
   while ($d = mysqli_fetch_array($r,MYSQLI_ASSOC)){
-  echo "<li>$d[FIRSTNAME] House Number: $d[HOUSE_NUMBER] Zip Code: $d[RESIDENTIALZIP5]</li>";
+   echo "<li>'$d[FIRSTNAME]' '$d[LASTNAME]' '$d[HOUSE_NUMBER]' '$d[RESIDENTIALZIP5]'</li>";
   }
+  echo "</ol>";
 }
 ?>
 <form method='POST'>