hi,
I have a perl script here which fetches data from the mysql database using the
fetchrow_array method. I have this script running on 2 different machines.
unfortunately this fetchrow_array call works on one machine and not on
another. I used the rows calls to check how many rows are returned by the
previous query. It shows me the correct value but then I try to fetch each row
of the result, it doesn't retrieve anything.
This is the code I am using.
&MakeDatabaseConnection;
&MakeDatabaseQuery($query);
while(@row = $sth->fetchrow_array)
{
print $row[0];
}
&BreakDatabaseConnection;
where the fetchrow_array doesn't pop any data.
Any idea why this could be happening?
Please help!!
Thanks
Ashwini
