Re: [PHP] php 5 and mysql failure
- From: dmjoseph@xxxxxxxxx ("Dan Joseph")
- Date: Wed, 30 Apr 2008 16:33:11 -0400
On Wed, Apr 30, 2008 at 2:31 AM, Yehudi Alexis Garrett <yehudi@xxxxxxx>
wrote:
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 bfore.
My question is, is there any kind of limit somewhere in php5 or in mysql?
Thanks for help,
YEHUDI GARRETT
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Have you tried output your SQL query and pasting it into mysql to see if it
runs? Sounds to me like it isn't a valid query, that would give you that
error.
You may also want to put some row count checking prior to trying to fetch
any rows.
--
-Dan Joseph
"Build a man a fire, and he will be warm for the rest of the day.
Light a man on fire, and will be warm for the rest of his life."
- References:
- php 5 and mysql failure
- From: Yehudi Alexis Garrett
- php 5 and mysql failure
- Prev by Date: Re: php 5 and mysql failure
- Next by Date: check if any element of an array is not "empty"
- Previous by thread: Re: php 5 and mysql failure
- Next by thread: check if any element of an array is not "empty"
- Index(es):
Relevant Pages
|
