title: how i can select only the type of the variables in the drupal watchdog database table?
body: <p>*****~PLZ HELP~***I want to spesialize the variables and take the type e.g 'Notice', 'Error'..In this code that follows execute something like this </p>
  
  <p>3710       a:6:{s:5:"%type";s:6:"Notice";s:8:"!message";s:24:"Undefined variable: path";s:9:"%function";s:3:"l()";s:5:"%file";s:44:"c";s:5:"%line";i:2469;s:14:"severity_level";i:5;}</p>
  
  <p>3711       a:6:{s:5:"%type";s:6:"Notice";s:8:"!message";s:24:"Undefined variable: path";s:9:"%function";s:3:"l()";s:5:"%file";s:44:"/c";s:5:"%line";i:2511;s:14:"severity_level";i:5;}</p>
  
  <p>3712       a:6:{s:5:"%type";s:7:"Warning";s:8:"!message";s:141:"Missing argument 2 for l(), called in on line 171 and defined";s:9:"%function";s:3:"l()";s:5:"%file";s:44:"";s:5:"%line";i:2458;s:14:"severity_level";i:4;}</p>
  
  <p>3713       a:6:{s:5:"%type";s:6:"Notice";s:8:"!message";s:24:"Undefined variable: path";s:9:"%function";s:3:"l()";s:5:"%file";s:44:"";s:5:"%line";i:2469;s:14:"severity_level";i:5;}**</p>
  
  <pre><code>    function blabla_page() {
  
            // Begin building
  
   the query.
        $query = db_select('watchdog', 'th')
          -&gt;extend('PagerDefault')
          -&gt;orderBy('wid')
          -&gt;fields('th')
          -&gt;limit(10);
  
      // Fetch the result set.
      $result = $query-&gt;execute();
  
        // Loop through each item and add to the $rows array.
        foreach ($result as $row) {
          $rows[] = array(
          $row -&gt; wid,
          $row -&gt; variables,
         );
        }
      // Headers for theme_table().
        $header = array('ID', 'Message');
  
      // Format output.
        $output = theme('table', array('header' =&gt; $header, 'rows' =&gt; $rows)). theme('pager');
           return $output;
         }
  </code></pre>