hey, I made i little database in a txt-file. If I type this into the mysql-prompt :
load data local infile "../data/software/soft.txt" into table soft
It works perfect (of course after creating the tables and stuff)
Now, i made a (still very simpel) php-thingie :
$link=mysql_connect ("localhost:3306", "user", "pass");
mysql_drop_db ("software");
mysql_create_db ("software");
mysql_select_db("software");
mysql_query("create table soft (name VARCHAR(50), link VARCHAR(50), version VARCHAR(20), remark VARCHAR(100))");
mysql_query("load data local infile \"../data/software/soft.txt\" into table soft");
mysql_close($link);
where the database gets erased if he exists, and a new one is created, with all the elements. Now, all of this works, BUT :
the "load data" thing doesn't, the table stays empty (is created but empty)
I'm not getting any error in my browser too
I guess this is a syntax error ?
O, if I leave the -ses away at \" he gives a parse error, which is normal i guess ? (double " ")
