2 replies to this topic

[msebar]

I went through most of your other post with the same problem but I can't find an issue with mine. Here is the code please help. I do have one more field in the table which is the id field (auto incremnet) I deleted the field in my database and still the same problem.
Thanks Mike

<?php

mysql_connect('localhost','user','password') or die(mysql_error()) ;
mysql_select_db('database');

$filename = "upload/uploadfile.csv";
$handle = fopen("$filename", "r");

    while ((@$data = fgetcsv($handle, 1000, "|")) !== FALSE) {
    $fname=str_replace("'","",$data[0]);
    $lname=str_replace("'","",$data[1]);
    $address=str_replace("'","",$data[2]);
    $city=str_replace("'","",$data[3]);      
    $state=str_replace("'","",$data[4]);    
    $zip=str_replace("'","",$data[5]);    
    $email=str_replace("'","",$data[6]);            
    $source=str_replace("'","",$data[7]);    
    $ip=str_replace("'","",$data[8]);    
    $date_time_stamp=str_replace("'","",$data[9]); 
		

$sql = "INSERT INTO contacts
(
fname,
lname,
address,
city,
state,
zip,
email,
source,
ip,
date_time_stamp
)
values 
('" .
$fname . "','" .
$lname . "','" .
$address . "','" .
$city . "','" .
$state . "')";
$zip . "')";
$email . "')";
$source . "')";
$ip . "')";
$date_time_stamp . "')";

mysql_query($sql) or die(mysql_error());


}

mysql_close();

?>

Edited by Orjan, 29 December 2009 - 05:32 AM.
Please use code or php tag when posting source

[Orjan]

The problem is that you have alot of ending parenthesis in your query, where it should be commas. Only after the last value there should be a parenthesis.

[msebar]

Thanks that worked. I have to stop working late nights. The code started to blur around midnight.closedeyes: