Update analytics.php

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

diff --git a/admin/functions.php b/admin/functions.php
index b796abb..3b784f0 100644 (file)
--- a/admin/functions.php
+++ b/admin/functions.php
@@ -1,8 +1,15 @@
 <?PHP
 
+function id2petition($id){
+  global $petition;
+  $q = "select petition_name from petitions where petition_id = '$id'";
+  $r = $petition->query($q);
+  $d = mysqli_fetch_array($r,MYSQLI_ASSOC);
+  return $d['petition_name'];
+}
 function id2group($id){
   global $petition;
-  $q = "select name from groups where id = '$id';
+  $q = "select name from groups where id = '$id'";
   $r = $petition->query($q);
   $d = mysqli_fetch_array($r,MYSQLI_ASSOC);
   return $d['name'];