Upload question answer word file DATA in mysql using php

[arvind vohra]

<?php

// Set Mysql Variables

$db = mysql_connect("localhost","root",""); 
mysql_select_db("testing",$db); 


$file = "c:/wamp/www/jquery/testdb.csv";
$fp = fopen($file, "r");
$data = fread($fp, filesize($file));
fclose($fp);

$output = str_replace("\t|\t", "|", $data);

$output = explode("\n", $output);

//$language_id = "1";
//$categories_id = 0;

foreach($output as $var) {
//$categories_id = $categories_id + 1;

$ques = explode("Q", $var);
$op1 = explode("(a)", $var);
$op2 = explode("(b)", $var);
$op3 = explode("(c)", $var);
$op4 = explode("(d)", $var);

$res = explode("result",$var);

echo $question = trim($ques[0]);
echo $option1 = trim($op1[1]);
echo $option2 = trim($op2[2]);
$option3 = trim($op3[3]);
$option4 = trim($op4[4]);
$result = trim($res[5]);

//echo " categories_id: " . $categories_id . " Artikelgroep: " . $Artikelgroep . "<br>";

mysql_query("INSERT INTO test (question,option1,option2,option3,option4,result) VALUES('$question','$option1','$option2','$option3','$option4','$result')") or die("Insert failed: " . mysql_error()); 

}
echo "Done!";


?>

NOTE :- I AM USING THIS SCRIPT BUT THE ALL DATA STORE IN A SINGLE COLUMN I WANT STORE THE DATA IN MULTIPLE COLUMN

[lyodmichael]

what error do you encounter?
do you get any data in your database when you done saving?