Re: php 5 and mysql failure
- From: Luuk <Luuk@xxxxxxxxxxx>
- Date: Wed, 30 Apr 2008 17:31:46 +0200
Caffeneide schreef:
I'm using a php script which performs three xml queries to other three
servers to retrieve a set of ids and after I do a query to mysql of
the kind
SELECT * FROM table WHERE id IN ('set of ids');
Although I'm sure the connection to the database is ok, I sometimes
get an error of this kind:
*Warning*: mysql_fetch_object(): supplied argument is not a valid
MySQL result resource in ...
This does not happen every time i run the script, only sometimes.
If I echo the query, copy and paste in phpmyadmin, or if I perform the
same query in a script that does only the query without the rest it
works!
After troubleshooting this issue I noticed that it usually failed when
I had a big set of ids (positive response from more than one server).
This means that the script used a bigger amount of memory and probably
more resources, but I did not get an "out of memory error", I got the
one described before.
My question is, is there any kind of limit somewhere in php5 or in
mysql (version 5)?
Thanks for help,
YEHUDI GARRETT
yes, there is..
http://tinyurl.com/3jgwjn
but, how many (or how much?) id's do get returned at max?
maybe you have to rewrite your solution to get a working one..
--
Luuk
.
- References:
- php 5 and mysql failure
- From: Caffeneide
- php 5 and mysql failure
- Prev by Date: php 5 and mysql failure
- Next by Date: Re: $_POST array question
- Previous by thread: php 5 and mysql failure
- Next by thread: Re: php 5 and mysql failure
- Index(es):
Relevant Pages
|
