CSV Upload error.....

[Fou-Lu]

I don't believe that MySQL tracks a rejection option for an insert ignore. What you can do is pull the number that was successful after the result:

PHP Code:

$iSuccessful += mysql_affected_rows($result); 


And initialize $iSuccessful to 0 before the while loop, and you can compare the $iSuccessful to the $counter. $counter should represent the total number of records, while $iSuccessful should indicate the number inserted.
You should consider blocking the query into sets of even 10 entries at a time to save the query counts. Depending on the datasize you could potentially get away with hundreds of entries per query.

[nani_nisha06]

Originally Posted by Fou-Lu

I don't believe that MySQL tracks a rejection option for an insert ignore. What you can do is pull the number that was successful after the result:

PHP Code:

$iSuccessful += mysql_affected_rows($result); 


And initialize $iSuccessful to 0 before the while loop, and you can compare the $iSuccessful to the $counter. $counter should represent the total number of records, while $iSuccessful should indicate the number inserted.
You should consider blocking the query into sets of even 10 entries at a time to save the query counts. Depending on the datasize you could potentially get away with hundreds of entries per query.

Thanks will try it and will post the results...

[nani_nisha06]

Originally Posted by Fou-Lu

PHP Code:

$iSuccessful += mysql_affected_rows($result); 


.

Fou-Lu,

These suggestion worked like a charm with some personal customization....

Really thanks full on your support....

Regards,
Nani