title: how to alter drupal-6 view-2 query
body: <p>I'm trying to update view query using drupal hook_views_pre_execute().<br>
  It's updating the query properly but even my query returning only couple of record, in view page it's showing pagination at the bottom but i've set the page limit 10. Can any one advise me how to resolve this issue.  </p>
  
  <pre><code>function mymodule_views_pre_execute(&amp;$view)
  { 
    switch($view-&gt;name)
    {
        case 'test_merchandise':
              $view-&gt;build_info['query'] = "MY QUERY";
              drupal_set_message($view-&gt;build_info['query']);
        break;
    }
  }
  </code></pre>