I have IIS running on Windows XP Pro
With PHP and MySQL support
I have a small little PHP script that is supposed to empty a table
and then load a local tab delimited text file into that same table.
After testing the script I found that it deletes the table just like I wanted it to...
BUT...
It doesn't load the text file into the table.
Here's the script:
<?php
// Database Connection
include("dbinfo.inc.php");
$db = mysql_connect("$server", "$username", "$password");
mysql_select_db($database,$db) or die (mysql_error());
mysql_query("DELETE FROM family");
mysql_query("LOAD DATA LOCAL INFILE 'D:/text/family.txt' INTO TABLE family");
?>
I also tried removing LOCAL from the string but that didn't work either...
