Retrieve data from webform or equivalent module

Hi Kasper,

I have this piece of code which would get the data in submitted forms in a variable in an array. Also as it is a db query you can use it in your custom module or theme it would work in both. :)

  // db query to get all sids (submitted webforms) present in nid = '12345' (put your webform's nid here instead of 12345)
  $webform_sids = db_query("SELECT sid FROM {webform_submitted_data} WHERE nid = '12345'");
  while ($webform_sid_array_raw = db_fetch_array($webform_sids)) {
    $webform_sid_order[] = $webform_sid_array_raw['sid'];
  }
  $webform_sid_order = array_unique($webform_sid_order);

  // db query to get data on the submitted webforms
  foreach ($webform_sid_order as $webform_each_sid) {
    $webform_data = db_query("SELECT data FROM {webform_submitted_data} WHERE sid = '%d'", $webform_each_sid);
    while ($webform_data_all = db_fetch_array($webform_data)) {
      // this is the variable where you have the data in the submitted webform in an array
      $webform_data_each[$webform_each_sid][] = $webform_data_all['data'];
    }
  }

This is what I have done and it worked for me.

Also I will keep searching for relevant contrib module in my free time and if you come across anything please do share it! :)

Regards,
BShetty