"MySQL server has gone away" after a few minutes

Programming in mysql: "MySQL server has gone away" after a few minutes on newest questions tagged mysql – Stack Overflow

I have 2 tables in a query designed to display/email the saved search info of users : users & wishlist.

The search info contains book titles among other things.

I have a first query designed to put into an array all the users that have records in the wishlist table.

Then using a foreach loop, via a second query, take each book title and run a search at various sites and save that information to screen or to an email.

The first run through takes about 3 minutes for the first user’s information to be assembled and yet, after this info is displayed, I see the dreaded “MySQL server has gone away”.

According to http://dev.mysql.com/doc/refman/5.0/en/gone-away.html – this shouldn’t happen so quickly.

The code for the second query is simple :

SELECT * FROM wishlist WHERE uid = " . $sendtouser . " ORDER BY wishid

After the information is compiled for that user, I have the following to close the loop and end the connection.

} while ($row_rsWishDetails = mysql_fetch_assoc($rsWishDetails));
mysql_free_result($rsWishDetails);

I have tried some other suggestions I have found on the web including :

ini_set('max_execution_time', 22222);
ini_set('mysql.connect_timeout', 500);
ini_set('default_socket_timeout', 600);

But nothing is fixing the problem.

Any ideas?

Thanks very much.

source: http://stackoverflow.com/questions/11424206/mysql-server-has-gone-away-after-a-few-minutes
Programming in mysql: programming-in-mysql