SQLite behaving bad?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux