note 52001 deleted from ref.sqlite by cmb

Note Submitter: bart at mediawave dot nl ---- SELECT tablename.columnname FROM table; will cause SQLite to return an array having tablename.field_name as the array index. (e.g. $result['tablename.field_name']) To let SQLite return an array having only field_name as the array index (e.g. $result['field_name']) you can issue a 'PRAGMA short_column_names = 1' query: sqlite_query($connection_id, 'PRAGMA short_column_names = 1'); This behaviour is more consistent with the other database extensions. For a full list of all pragmas visit: http://sqlite.org/pragma.html