Re: RE: Basic SQLite test failing..

Ahh, I'm not very familiar with php, should have looked into the effects of the '@' symbol. Once removing the symbols, running via CLI, it fails with; 'Call to undefined function: sqlite_open()' whereas, running via apache, it fails with; 'Call to undefined function: sqlite_query()' I have sqlite and sqlite_php installed and enabled in php.ini (there's an entry under phpinfo()). Any ideas why it may be failing? Thanks again. On 10/30/05, JeRRy <jusa_98@yahoo.com> wrote: > > Hi, > > > > Errors are more than likely not being produced because of the '@' symbol. Try > removing this and see how you go. Also check your code for syntax errors. These will be produced > within the errors. > > > > J > > > > ---------------------------------------------start of > message------------------------------------------- > > > 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 nevercomes out, i.e. none of the rest of the code is hit. When running viaapache and mod_php, it > gets out of 'sqlite_open' with a validconnection but never comes out of the first > 'sqlite_query' call.It does this without any errors or warnings. The database file > ispresent 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.5Any ideas where things are going wrong? Or perhaps tips on > improvingdebug output. Any help would be > appreciated,Eoin. > > ------------------------end of message------------------- > > > > --------------------------------- > Do you Yahoo!? > Find a local business fast with Yahoo! Local Search >