I'm using the below to open a text file read all the lines into an array which i then echo out just to make sure the array contains what i want (which it does) But when i try to do an mysql_query update with the array it only pulls the last name from the text file eg:
Text file has 10 names
The echo, echo's the 10 names
The update inserts 10 Johns into the database
Can anyone give me any pointers?
Code: Select all
<?php
$fc=file("test.txt");
foreach($fc as $line)
{
echo $line;
$result = mysql_query("UPDATE test SET Name='$line' WHERE Name='0'") or die(mysql_error());
}
?>Slash.