I don't see anything obvious but have a look at the rows it is considering
duplicates. Are they the same list each time? By the way, it looks like
you're connect()ing once for each query you are executing. You should only
connect once at the beginning of the program.
Hope this helps,
On Sun, Sep 08, 2002 at 12:48:20AM +0900, Jean-Christian Imbeault wrote:
> The problem I am seeing is that when I run my PHP program I have it
> print out how many times the data it wanted to insert was already in DB
> (a duplicate entry from the data file presumably). I have run the
> program four times and each time I get a different result!
>
> But the total number of inserted items is always the same ...
>
> Each are the results after four runs:
>
> Duplicate Items Total DB inserts
> 5099 14285
> 5000 14285
> 5125 14285
> 5098 14285
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.