Update analytics.php

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

diff --git a/admin/search.php b/admin/search.php
index bd885de..0f17dbb 100644 (file)
--- a/admin/search.php
+++ b/admin/search.php
@@ -11,11 +11,11 @@ if ($_POST['LASTNAME']){
 }
 if($LASTNAME != ''){
   echo "<ol>";
-  $q = "select * from VoterList where LASTNAME like '%$LASTNAME%' ";
+  $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>";
 }