[phpesp-general] Displaying number of responses

[Gary Ashton-J. <gas...@f2...>]

We typically have dozens of surveys running at any one time and found it 
useful to get a quick summary of responses per survey on the 'View 
Survey Results' page. I put this patch into v1.3 but forgot to send it 
to mailing list. Here's an updated patch for v1.4 if anyone is 
interested. It simply adds an extra column ('Resp') of total responses 
for each survey after 'Owner' and 'Group'.

Rgds

Gary


--- results.inc    Wed Jul 10 17:08:45 2002
+++ results.inc.old    Wed Jul 10 16:28:58 2002
@@ -97,15 +97,10 @@
         <th align="left"><?php echo(_('Title')); ?></th>
         <th align="left"><?php echo(_('Owner')); ?></th>
         <th align="left"><?php echo(_('Group')); ?></th>
-        <th align="left"><?php echo(_('Resp')); ?></th>
     </tr>
 <?php
     while(list($sid,$name,$title,$owner,$realm) = 
mysql_fetch_row($result)) {
 
-        $sql2 = "SELECT count(*) from response where survey_id = $sid";
-        $result2 = mysql_query($sql2);
-        list($resp) = mysql_fetch_row($result2);
-            
         if($bg != $ESPCONFIG['bgalt_color1'])
             $bg = $ESPCONFIG['bgalt_color1'];
         else
@@ -121,7 +116,6 @@
         <td><?php echo($title); ?></td>
         <td><?php echo($owner); ?></td>
         <td><?php echo($realm); ?></td>
-        <td><?php echo($resp); ?></td>
     </tr>
 <?php
     }