Posted by Bob Bedford on 09/26/05 12:52

"Neil Trigger" <nt018a9036@blueyonder.co.uk> a écrit dans le message de
news: _7BZe.6310$fl6.3231@fe2.news.blueyonder.co.uk...
> $query_1='INNER JOIN mod ON type.modcode = mod.modcode';
> $query_2='INNER JOIN mak ON mod.makecode = mak.makecode';
>
> SELECT * FROM type ($query_1)&&($query_2)
>

I've created an other table copying the type into tbltype.

syntax:
drop table if exists tbltype;
CREATE TABLE IF NOT EXISTS tbltype DEFAULT CHARACTER SET latin1 COLLATE
latin1_swedish_ci(SELECT * FROM type);

Then I've changed the query and now it does work always.
What's strange anyway is that the type table is 10.1MB and the new tbltype
is 8.9, with exactly the same number of records, same character set and co.
Only thing, there is no key defined for the new table.

I won't change all my php code, I would preffer to fix the problem on the
type table instead of creating a new one and then to change my php code

Bob

[Back to original message]