Last updated April 6, 2012. Created on February 23, 2011.
Edited by vectoroc, zahidansari. Log in to edit this page.

<form action="?q=node/4376" method="post">
 <select name="lang">
  <option value="">--Select Language--</option>
  <option value="mr">Marathi</option>
  <option value="or">Oriya</option>
  <option value="pa">Punjabi</option>
  <option value="ta">Tamil</option>
  <option value="te">Telugu</option>
  <option value="as">Asamese</option>
  <option value="bn">Bangali</option>
  <option value="ml">Malayalam</option>
  <option value="gu">Gujrati</option>
  <option value="hi">Hindi</option>
  <option value="kn">Kannda</option>
  <option value="ks">Ks</option>
</select>
 <input type="submit" name="submit" value="filter"/>
</form>

 include_once './includes/bootstrap.inc'; 
 //drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

ini_set('display_errors', 1);
      
        $select_lang = $_POST['lang'];
        
        if($select_lang=="")
          {
             $select_lang='hi';
          } 
         $query = " select v1.title english_title,
                         v1.body english_content,
                         v2.title Hindi_title ,
                         v2.body Hindi_body,
                         v2.lang language_code
                         from  view_health_topic v1,view_health_topic v2
                         where v1.tid=v2.tid and v1.lang='en' and v2.lang = '".$select_lang."' " ;

            $result = db_query($query);
  //        echo $query;
            echo "";
            echo "" ;

          while($row = db_fetch_object($result))
           {
            echo "";
            echo "";
            echo "";
            echo "";
            echo "";
            echo "";
            echo "";
           }
           echo "
English title English Body Language Title Native language body
".$row->english_title."".$row->english_content."".$row->language_code."".$row->Hindi_title."".$row->Hindi_body ."
";

Looking for support? Visit the Drupal.org forums, or join #drupal-support in IRC.