title: Importing CSV data into MySQL table
body: <p>I have a CSV file which contains data seperated with tabs. I need to import the data into a MySQL table which consists of two columns. The first CSV column should go into the first column of the table and similarly for the second.</p>
  
  <pre><code>&lt;?php 
  $con=mysql_connect("localhost","root",""); 
  mysql_select_db("translation",$con); 
  $open=fopen("EH_excel.txt","r"); 
  while(($get=fgetcsv($open,1000,","))!==false) { 
    mysql_query("insert into   dictionary(english,croatian)     
    values('".$get[0]."','".$get[1]."')"); 
  } 
  fclose($open); echo "Import Done."; 
  ?&gt;
  </code></pre>
  
  <p>Can anybody help me?</p>