On Tuesday 17 February 2004 04:41 pm, Gerard Samuel wrote:
> 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".
>
Just an update about this.
Due to changes in SQLite, the problem that I've described in this email, is
now the default behaviour of SQLite.
So if you get bitten by this, its up to you to figure a way around this.
> 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
