Jun 24, 2017, 7:15 AM
Why are you fetching the row inside the body of the loop? Doing That is the cause of your problem.
Re: [kwatts59] Problem with fetchrow_array
The fetch statement (@row assignment) should be in the while loop initialization.
Why are you fetching 2 fields but only ever use the first?
You should enable RaiseError in the connection statement and not worry about using the die statement on the prepare, execute and fetch statements. If you must, you could use eval as Bill suggested to trap the errors.
Is better written as:
$gene_symbols[$i] = $row;
push @gene_symbols, $row;
(This post was edited by FishMonger on Jun 24, 2017, 7:18 AM)