Take out the @ symbols so you can get some errors?
On Sunday 30 October 2005 3:03 am, Eoin Hennessy wrote:
> Hello, I have the following very basic sqlite test harness:
>
> <?php
> $dbconn = @sqlite_open('testdb');
>
> if ($dbconn) {
> @sqlite_query($dbconn, "CREATE TABLE test_table (test_id INT);");
> @sqlite_query($dbconn, "INSERT INTO test_table VALUES (100)");
>
> $result = @sqlite_query($dbconn, "SELECT test_id FROM test_table");
> var_dump(@sqlite_fetch_array($result, SQLITE_ASSOC));
> } else {
> print "Connection to database failed!\n";
> }
> ?>
>
> When running via CLI the script goes into 'sqlite_open', but never
> comes out, i.e. none of the rest of the code is hit. When running via
> apache and mod_php, it gets out of 'sqlite_open' with a valid
> connection but never comes out of the first 'sqlite_query' call.
>
> It does this without any errors or warnings. The database file is
> present with correct permissions. I'm running a standard php install.
>
> I am using:
> php 4.4.0
> sqlite 3.2.7
> sqlite-php 0.0.5
>
> Any ideas where things are going wrong? Or perhaps tips on improving
> debug output. Any help would be appreciated,
>
> Eoin.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php