Loop Not Working

[shage]

$handle = fopen("csv.txt", "r");
while ($line = fgetcsv($handle, 1000, ",")) {
$title = $line[0];
$url = $line[1];
$image = $line[2];
$query = "INSERT INTO videos (`title`,`url`, `image`, `date`, `spon`, `cat`) VALUES ('$title','$url', '$image', '2008-09-25', 'NA', 'NM')";
$result = mysql_query($query);
} 
fclose($handle);

 

Some reason it only adds the first line of the csv, thank you

[redarrow]

Look like the loop......

 

have you tried it without ordering the array();

 

and why ant you useing mysql_real_escape_string($_POST['example_name']);

[PFMaBiSmAd]

You are probably having a line-ending problem and the whole file is being read into the first line. Display the actual data to see what is being read from the file. Add the following inside of your loop -

 

echo "<pre>";
print_r($line);
echo "</pre>";

[shage]

Array
(
    [0] => First Bday
    [1] => 1a.wmv
    [2] => 1a.jpg
)

Array
(
    [0] => First Bday
    [1] => 2a.wmv
    [2] => 2a.jpg
)

[PFMaBiSmAd]

I'm going to guess that your table defines title as an index and the second query is failing due to a duplicate index error.

 

All code must check for any possible error, how else will you know if it worked or not? At a minimum, change your mysql_query to get mysql/php to tell you if the query fails and why it failed -

 

$result = mysql_query($query) or die("Query failed: $query<br />Mysql error: " . mysql_error());

[shage]

its erroring on the key which is the ID but some reason its not incrementing as its set for auto

[PFMaBiSmAd]

You would need to post your table definition and the actual error message to get actual help with the problem.