Currently using sqlite 2.8.11 (distributed by php snaps) with php4.3.5rc2 on windows XP. Several months ago, I added support for sqlite in a database abstraction class I created. It worked great then. Im trying to see if things are still ok today, and its not. For example executing the select query -> select f.foo, b.bar from table f, table b where f.id = b.id; Should return result table fields "foo" and "bar". Instead its returning result table fields "f.foo" and "b.bar". Example script <?php // sqlite connection parameters produce $conn resource id $sql = 'SELECT f.foo, b.bar FROM table f, table b WHERE f.id = b.id'; $result = sqlite_query($conn, $sql); if ($result === false) { die('For some reason'); } while($row = sqlite_fetch_array($result, SQLITE_ASSOC)) { // The expected results return nothing var_dump($row['foo'], $row['bar']); // The unexpected results return data var_dump($row['f.foo'], $row['b.bar']); // You get the correct values } ?> So has anyone experienced this with the current sqlite/php combination? This used to work correctly with sqlite 2.8.3 (distributed by php snaps) Were there any notices that I may have missed over these past months?? Thanks for any help you may provide... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php