Mass MySQL INSERT

["Travis Conway" <travis@xxxxxxxxxxxxxxxxx>]

I am fairly new to the concept of working wity mysql and php.  I am looping thru a text file full of county names and attempting to add these to a database.

Now the table exists and if I enter the SQL statement manually against the database it works.  The user also has read and write permissions to the table and the columns in the table.

Here is my php code:
 $lines = file("/tmp/new1.txt");
 foreach ($lines as $line_num => $line) {
  echo($line . '... ');
   $link = mysql_connect('naabe', 'naabe', 'xxxxxxxxx')
    or die('could not connect: ' . mysql_error());
    // I use substr to remove the space at the end of every line.
   $sql = "INSERT INTO countries (country) VALUES ('" . substr($line,0,strlen($line)-1) . "')";
   echo ($sql . ' ...<br>');
   mysql_query($sql);
   mysql_close();
  flush();
 }

This is how I configured php4.3.9
./configure --enable-so --with-mysql=/usr/local/mysql --enable-filepro --with-apx2=/usr/local/apache2/bin/apxs --with-jpg --with-png --with-xml

It will print to the screen the line and the SQL statement correctly.  The password is correct.  The database name is naabe, the user is naabe.

Anyone know what I could be doing wrong?

Trav