[code] <?php include("login.inc.php"); mysql_connect($hostname,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $file = file("names.txt"); foreach ($file as $names) { //echo just to see its working echo $names."<br>"; mysql_query("INSERT INTO vote (id,name,vote) VALUES (NULL,$names,'')"); } mysql_close(); ?>[/code] Hello, I have a text file which is a list of names, each on its own line. I'm trying to use the above code to take each name and insert it into a mysql database. My problem is, that mysql_query will only take a value if it is a number. If I replace names in the text file with numbers it works perfectly. I have also tried replacing file() with file_get_contents() and exploding it, same problem. I am possitive my database is set up correctly, I tested the same code by replacing $names with actual text and it inserted just fine. As you can probably tell I'm new at this, I appreciate any help that can point me in the right direction here.