mysql_query overflow ?

Hi all,

I would like to suggest you some refelxion about this :

I run this simple code :

....
$res = mysql_query ($requete, $connexion) or die(mysql_error());
while (is_object($elt = mysql_fetch_object($res) ) ) {

....
}

with in $requete a SQL commande that I have run it on a mysql console
with succes.

If the result of the query is very big (but I don't know exactly the
limit), I get the message :
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL
result resource ...

I think that there is a problem in the function mysql_query.
Who knows how to avoid it ?

Regards.

Patrick