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

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.

Stefan

[Back to original message]