[sqlite] problem with SELECT * when using multiple FROM tables

When working on a DB layer, and migrating a project from MySQL to SQLite, I've noticed that this is ok with MySQL: CREATE TABLE b ( afield1 integer, afield2 integer); CREATE TABLE b ( bfield1 integer, bfield2 integer); $query = sqlite_query('SELECT * FROM a, b WHERE afield1=bfield1',$db); and/o

Re[2]: [sqlite] PHP 5.0.2 / Win sqlite_query problem

>> When I try to execute the same query using sqlitecc.exe it works just fine. >> DRH> This fact suggests that the problem is in PHP or the application program, DRH> not in SQLite. There can hardly be any problem with sqlite_query($db,$query) application code... Is SQLite in PHP 5.0.2 supposed

[sqlite] PHP 5.0.2 / Win sqlite_query problem

I am trying to migrate my opensource project (http://blogcms.com/) from MySQL 4.0 (mysql) and MySQL 4.1 (mysqli) to SQLite as well. Seems pretty easy with DB layer, but... when I open DB via sqlite_open() and execute few CREATE TABLE queries, via sqlite_query(), the connection is dropped and I c