cannot import excell table in mysql

[kkshansid]

cannot import table in mysql
1i saved my excell file in csv formate
2i made a data base in mysql
3i made a table with 5 fields
4i run this file


error
Parse error: syntax error, unexpected T_STRING in C:\wamp\www\tes t\hi.php on line 16

<?php
echo"hi";
 $conn=mysql_connect("localhost","root","");
             if(!($conn)) die("could not connect");
 
            $db=mysql_select_db("asdf");
            if(!($db)) die("database not found");
LOAD DATA INFILE 'D:\backup\institutes.csv' INTO TABLE 'inst'; 
?>

[wizardry]

here is a link for what your trying to acomplish
http://blog.tjitjing.com/index.php/2...in-5-easy.html

[Canabeez]

@kkshansid
I think you missed, mysql_query() part, and BTW this (Parse error: syntax error, unexpected T_STRING in C:\wamp\www\tes t\hi.php on line 16) is PHP error, not mySQL. Your code should look like:

            $conn=mysql_connect("localhost","root","");
            if(!($conn)) die("could not connect");
 
            $db=mysql_select_db("asdf");
            if(!($db)) die("database not found");
            mysql_query("LOAD DATA INFILE 'D:\backup\institutes.csv' INTO TABLE 'inst';", $conn);