Posted by Bob Bedford on 09/25/05 13:21

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 ?

[Back to original message]