Posted by Bob Bedford on 09/14/05 09:11

Hello Kevin, thanks for the reply,
> Do you mean the query string is long, or the result set is? How long are
> we talking?
The query itself, it must return 2 results quite shorts.

> Some things to try:
>
> Right after executing the query if you don't get a result, do an "echo
> mysql_error();" This will tell you if there was an error message.
>
> Check MySQL's "max_allowed_packet" variable. This can cause problems with
> long queries (although you should get an error).
>
> Is it possible that the result of your query really is empty (i.e., the
> WHERE or HAVING clauses aren't satisfied)?
No, as the query is ALWAYS the same and no changes are made on the database
(no new records, no changes at all).
There is no error, that's the strangest thing.

It's like the query wouldn't return any result, but when done again, then it
returns a result. The behaviour is quite random. It may work 5 times and
then not 2 times then work again once then not 6 times....

very strange.

[Back to original message]