note 52001 added to ref.sqlite

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 ---- Manual Page -- http://www.php.net/manual/en/ref.sqlite.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+52001 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+52001&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+52001&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+52001&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+52001&report=yes&reason=useless Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+52001&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+52001&report=yes Search -- http://master.php.net/manage/user-notes.php