Load data infile problems

[conjurer]

I am trying to load a file into a table using

LOAD DATA INFILE 'member.txt' INTO TABLE member;

When I run that I get the following error:

ERROR 1105: File '.\sampdb\member.txt' not found (Errcode: 2)

Which I don't understand because the current directory is where the file is located. When I do a "dir" at the cmd prompt it returns:
Directory of C:\Documents and Settings\RLane\My Documents\Active Web Sites\Localhost\sampdb

and the listing of files shows the member.txt file.

What am I doing wrong?

😕

[Mark_Nordstrom]

you prob have it set to load data from a server file. Have it load it from a form that you submit the file in.

Try

$result = mysql_db_query('database' ,"LOAD DATA LOCAL INFILE '$form_data' INTO TABLE member FIELDS TERMINATED BY '' LINES TERMINATED BY '\r\n' ") or die(mysql_error()); 

Now you can edit the fields terminated by " " right now its a tab. Or you can make it a , for csv. if you need to convert the file to csv let me know i got that code to lol.

[Mark_Nordstrom]

The form would be <form method="post" action="filename.php" enctype="multipart/form-data">
<p>
<input type="file" name="form_data" size="40">
<input type="submit" name="submit" value="submit">
</form>