loop problem while the content of csv file is trying to insert into database

[sumaabey]

my code

<?
//include("../mysqlconnect.php");
$link = mysql_connect("localhost","root","")
       or die("Could not connect: " . mysql_error());
 mysql_select_db("suma");
 
include("include/upload.inc.php");
if(isset($_POST['upload']))
{
$deli=$_POST['delimeter'];
 
$userfile=$_FILES['userfile']['name'];
$userfile_tmp=$_FILES['userfile']['tmp_name'];
$userfile_type=$_FILES['userfile']['type'];
$userfile_size=$_FILES['userfile']['size'];
$dir="upload";
$filename=basename($userfile);
move_uploaded_file("$userfile_tmp","$dir/$filename");
$row= 1;
$fp = fopen("$dir/$userfile", "r");
$s="";
$s1="";
$s2="";
 
while (($data = fgetcsv($fp, 100000, "$deli")) !== FALSE) 
{
    $num = count($data);
    $row++;
    if($row==2)
    {
    for ($c=0; $c < $num; $c++) 
    {
        $s.=$data[$c]." VARCHAR (200) not null,";
        $s2.=$data[$c].",";
        $s1.="'$data[$c]',";
    }
echo      $sql="create table temp1(id int(20) not null auto_increment,".$s."extra varchar(200) not null, primary key(id))";
    mysql_query($sql)or die("could not create");
 
     $sql1="insert into temp1 (".$s2."extra) values (".$s1."'choose')";
    mysql_query($sql1)or die("could not insert");
    }
 
    if($row > 2)
    {
    $s1="";
    for ($c=0; $c < $num; $c++) 
    {
          $s1.="'$data[$c]',";
    }
     $sql2="insert into temp1 (".$s2."extra) values (".$s1."'choose')";
    mysql_query($sql2)or die("could not insert");
    }                
}
 
fclose($fp);
}
 
?>
 
<table>
 
<form action="" method="post" enctype="multipart/form-data" name="form3" id="manu">
 
 <tr class="greyBG"> 
      <td width="60%" height="33"> <div align="left">Please Enter the delimeter 
        </div></td>
      <td width="40%"><input type="text" name="delimeter"> </td>
    </tr>
<tr><td>Upload CSV file</td><td><input name="userfile" type="file"></td>
 
 
 
 
</tr>
<tr><td colspan="2">  <input type="submit" name="upload" value="upload"></td></tr>
</form>
</table>

[Please use CODE tags when posting source code. Thanks! --pbmods]

[pbmods]

Heya, sumaabey.

What do you want your code to do? Give an example.
What is your code doing that you don't want it to do? Give an example.
What is your code *not* doing that it is supposed to? Give an example.

[sumaabey]

i want to import csv file into mysql data can you help me?

[pbmods]

Heya, sumaabey.

i want to import csv file into mysql data can you help me?

MySQL has a LOAD DATA INFILE command for that.