eg SELECT * FROM table1 AS t1 WHERE t1.blah NOT IN (SELECT t2.blah FROM table2 AS t2)
wouldn't work, and phpDiplomacy uses queries like these quite a lot.
Sorry about that, bug your host to upgrade, or use PostgreSQL. (I wrote the PostgreSQL module because my host had 4.0.)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
most of hosting use it...
:)
4.0 doesnt support sub queries.
eg SELECT * FROM table1 AS t1 WHERE t1.blah NOT IN (SELECT t2.blah FROM table2 AS t2)
wouldn't work, and phpDiplomacy uses queries like these quite a lot.
Sorry about that, bug your host to upgrade, or use PostgreSQL. (I wrote the PostgreSQL module because my host had 4.0.)