|
|
Posted by Bob Bedford on 09/25/05 15:06
"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.
Bob
Navigation:
[Reply to this message]
|