Posted by Stefan Rybacki on 09/25/05 18:40

Bob Bedford wrote:
> "Stefan Rybacki" <stefan.rybacki@gmx.net> a écrit dans le message de
> news: 3pnd47Fb7mtiU1@individual.net...
>
>> Bob Bedford wrote:
>>
>>> Sometimes, WITH EXACLY THE SAME QUERY AND THE SAME RECORDS IN MY
>>> DATABASE, i get results, sometimes I get no results.
>>> I don't change the query, and when doing a query refresh in
>>> phpmyadmin, then sometimes it fails, sometimes not.
>>> Here is the simplest query that fails sometimes:
>>>
>>> SELECT *
>>> FROM type
>>> INNER JOIN mod ON type.modcode = mod.modcode
>>> INNER JOIN mak ON mod.makecode = mak.makecode
>>>
>>> this query works always.
>>> SELECT *
>>> FROM type
>>> INNER JOIN mod ON type.modcode = mod.modcode
>>>
>>> So it seems that as soon as you put 2 inner joins with a table named
>>> "type"
>>> then it fails: sometimes I get records, sometimes not.
>>> with query results, the result count is 0-0 (1 total) (in phpmyadmin)
>>> so even when it works, mysql server doesn't return the correct number
>>> of records with the first query. The second query is ok
>>>
>>> any idea ?
>>>
>>
>> Did you tried to send this query from the console or another
>> application like mysqlcc? Maybe its because of phpmyadmin.
>
>
> Hi Stefan, thanks for the reply-
> Actually we got the error from the php code in the site.
> the query on the dev machine (XP) doesn't get this error. It actually works
> on the server (Linux) I can't test on the console, and it fails, in our
> PHP code and in the phpmyadmin code.
>
> So I can't test like you said.
>

Do you get any errors, in the case there are no results?

Stefan


> Bob
>

[Back to original message]