form upload question

[natman3]

I am trying to use this code to insert the file into my dba but am not sure if it works i get an error.

I am also looking to create a form that will create a table in my dba so that i can query it to put the file in. I know that this script does not creat the table so if anyone knows how i can create a form to do this or if anyone knows of documentation on how to do this i would be greatful

<?
if(isset($POST['upload']))
{
$fileName = $FILES['userfile']['name'];
$tmpName = $FILES['userfile']['tmp_name'];
$fileSize = $FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$fp = fopen($tmpName, 'r');
$content = fread($fp, $fileSize);
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}

include 'library/config.php';
include 'library/opendb.php';

$query = "INSERT INTO upload (name, size, type, content ) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
include 'library/closedb.php';

echo "<br>File $fileName uploaded<br>";
}
?>

below here is the form that i created.

<form action="" method="post" enctype="multipart/form-data" name="uploadform">
<table width="350" border="0" cellpadding="1" cellspacing="1" class="box">
<tr>
<td width="246"><input type="hidden" name="MAX_FILE_SIZE" value="2000000"><input name="userfile" type="file" class="box" id="userfile">
</td>
<td width="80"><input name="upload" type="submit" class="box" id="upload" value=" Upload "></td>
</tr>
</table>
</form>

[Roger_Ramjet]

Do you mean you ned to first create the table for this script? Personally, I would say use phpmyqdmin or a similar db admin tool. But if you do not have access to one then you need to run a Create Table query. Best to read the manual so you learn how for the future. Have a go and post here when you run into problems, we'll help you fix them.

[natman3]

What i am actually tring to accomplish is the ability to upload a tab delimited file through the use of a form like you can within the myphpadmin. I am wanting to do this outside the admin tool be cause i dont want to have to go into the myadmin when i upload such file. The fields will always remain the same I just want the ability to change the data in the fields by uploading a file through a form on a web page rather than going through the admin. My guess is that I would need to somehow parse the file and place the content in the apropriate row i am just not sure how to do this in php. I know that the mysql command is this.
//LOAD DATA LOCAL INFILE '/tmp/phpCllwKc' INTO TABLE '2004Results' FIELDS TERMINATED BY '\t' ENCLOSED BY '\"' ESCAPED BY '\' LINES TERMINATED BY '\n'

[Roger_Ramjet]

You just run mysql_query the same as with any sql statement.