Duplicate entry '' for key 1

[natman3]

Does anyone know what this could mean?

[planetsim]

You have a Primary key or Uniuqe key field. Basically the error explains it. One the Fields which are Primary or unique has record with the same field value.

If this is primary set the field to auto_increment, if its unique you may need to check the table and that field for a unique result.

[natman3]

This is what my php code looks like. I am using a form to upload a file and i use isset to check to see if i hit the upload button which then checks to ensure i have a $FILES then i take the $fileName and parse the file into the dba table fields however I have come to realise that i might not be getting the file from the form and parsing it do you have any suggestions on if i am doing this correctly with the $FILES['userfile']['name']

<?php
if(isset($POST['upload']) && $FILES['userfile']['size'] > 0)
{
$fileName = $FILES['userfile']['name'];
$tmpName = $FILES['userfile']['tmp_name'];

				for($i=0; $i<sizeof($fileName); $i++) 
				{ 
					$line = trim($fileName[$i]); 
					$arr = explode("\t", $line); 
					#if your data is comma separated
					# instead of tab separated, 
					# change the '\t' above to ',' 

					$query = "INSERT INTO 2004Scores (Bib, FirstName, LastName, Addr, City, State, Zip, Email, TimeOfDay) ". 
					"VALUES ('". implode("','", $arr) ."')"; 

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

					# first get a mysql connection as per the FAQ 

					$hostname_mydba = "localhost"; 
					$database_mydba = "ResultsDB"; 
					$username_mydba = "root"; 
					$password_mydba = "pass"; 
					$mydba = mysql_connect($hostname_mydba, $username_mydba, $password_mydba) or trigger_error(mysql_error(),E_USER_ERROR); 
					mysql_select_db($database_mydba); 

					mysql_query($query) or die(mysql_error()); 
				}
				fclose($fp);


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

			} 
			?>

[planetsim]

Well I cant see how your uploading the file. There doesnt appear to be a move_uploaded_file or copy in that script.

(please use [php][/php] tags when posting PHP code).

Also the error your getting is not associated with your PHP its database related.

[natman3]

Which one should i use? Where would i place either the move_upload_file() or the copy() in my script inorder to get the file parsed