D.W. said: > I want to write results of a query in an ascii file. > > In the shell this works: > sqlite> .mode list > sqlite> .separator | > sqlite> .output test_file_1.txt > sqlite> select * from tbl1; > sqlite> .exit > > I tried similar querys in php, but without any success. > It seems that Sqlite in php doesn't know the output command. How is the > synthax in php? Can anybody help me? > Daniel
The normally accepted procedure in most languages is to retrieve your result set from "select * from tbl1", then write that result set to a file using the facilities of the programming language. The approach you're trying is to use the features of the sqlite shell rather than the features of the sqlite database. PHP doesn't give you access to the shell, only the database. Clay Dowling -- Lazarus Notes from Lazarus Internet Development http://www.lazarusid.com/notes/ Articles, Reviews and Commentary on web development