newbie needs help with csv

natman3

I am trying to parse this file and place it in a table called 2004Results however I get this error

insert into 2004Results values ('')
No Database Selected

does anyone know why?

<?php

		   # first get a mysql connection as per the FAQ

			$hostname_mydba = "localhost";
			$database_mydba = "ozarkDB";
			$username_mydba = "root";
			$password_mydba = "password";
			$mydba = mysql_pconnect($hostname_mydba, $username_mydba, $password_mydba) or trigger_error(mysql_error(),E_USER_ERROR); 


		  $fcontents = file ('./OzarkDB.xls'); 
		  # expects the csv file to be in the same dir as this script

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

				  $sql = "insert into 2004Results values ('". 
							  implode("','", $arr) ."')"; 
				  mysql_query($sql);
				  echo $sql ."<br>\n";
				  if(mysql_error()) {
					 echo mysql_error() ."<br>\n";
				  } 
			}

		?>

Dvector

First off, try not to use mysql_pconnect unless you really have to. Use mysql_connect instead.

mysql_connect($hostname_mydba, $username_mydba, $password_mydba);

Next, the reason you are getting the "No Database Selected" error is because you have not selected your database yet. To do so, simply run the query:

mysql_select_db($database_mydba);

That should set you up.

natman3

I added those two mysql statments but i get this error now. Do I need to somehow write in php the code for the names of the fields. If so these are the names i wish to have
Bib FirstName LastName Address City State Zip Email FinTimeOfDay

Here is the error
insert into 2004Results values ('')
Column count doesn't match value count at row 1

Dvector

If you are inserting a row that fills each column then you do not need to specify the columns you are inserting too. MySQL will just add the data to each column as specified in the INSERT.

Your SQL statement should look something like this (assuming Bib is your primary key column):

$SQL = "INSERT INTO 2004results VALUES(null, '$arr[0]', '$arr[1]', '$arr[2]', '$arr[3]', 
  '$arr[4]', '$arr[5]', '$arr[6]' '$arr[7]', '$$arr[8]')";

I'm unsure about using implode to build a query, but this code above should work. The number of elements being inserted (including the null argument) must equal the number of columns in the table for this particular query to work.