webform to see customisable petition results?

Okay, after a little work, I've found a working solution. In the confirmation message section, insert this text/code...

echo "Thank you for signing the petition.  We hope to use this as a tool to support our efforts.";

$nid=arg(1);

function _webform_results_table($nid) {
  include_once(drupal_get_path('module', 'webform')."/webform.inc");
  // Load Components
  _webform_load_components();

  $header = array();
  $rows = array();
  $cell = array();

  
  // Get all the component cid and names for the node
  $query = 'SELECT cid, name, type, extra FROM {webform_component} WHERE nid = %d ORDER BY weight, name';
  $res = db_query($query, $nid);
  while($component = db_fetch_array($res)) {
    $components[] = $component;
  }

  // Get all the submissions for the node
  $submissions = _webform_fetch_submissions($nid);
  // Generate a row for each submission
  foreach ($submissions as $sid => $submission) {
    $componentHeaders = array();

    // Generate a cell for each component
    foreach($components as $component) {
      $component['extra'] = unserialize($component['extra']);
      $tableFunction = "_webform_table_data_".$component['type'];
      if (function_exists($tableFunction)) {
        $submissionOutput = $tableFunction($submission['data'][$component['cid']],$component);
        if ($submissionOutput !== NULL) {
          $componentHeaders[] = $component['name'];
          $cell[]   = $submissionOutput;
        }
      }
    }
    
    $rows[] = $cell;
    unset($cell);
  }
  if (!empty($componentHeaders)) {
    $header = array_merge($header,$componentHeaders);
  }

  return theme('table', $header, $rows);
} // end function _webform_results_table($nid)

$content= _webform_results_table($nid);

return $content;

Make sure you select "PHP Format" under the "Input Format" dropdown. For me, it worked exactly as I'd hoped!

I've run into one stumbling block with this approach. The only way I can allow the website visitor to see the petition result is if I provide the anonymous user privileges to "access webform results" within the 'Administer --> Access Control' settings.

Unfortunately, I think there's a bug here regarding the "access webform results" privilege. I've set it up so that the administrator has full webform privileges (all are checked) but the authenticated and anonymous user have ONLY the 'access webform results' privilege.

For these two account types, "webform" is displayed at the root level of the navigation menu (and this links to http://examplesite.com/admin/webform). This option does not appear to an administrator account, except where it should (under Admin --> webform). When this root navigation choice is clicked, the authenticated & anonymous user have full access to administering the webform -- and this should NOT be happening.

Anyone else seeing this anomaly? Know how to remedy it? Thanks!