Creating SQLite Database for download....

hey guys...

Im posting this on PHP, as im not sure if its best suited here or in the database forum...

I can create a sql lite db quite simply in php...

i can also make this downloadable... by "readfile" it back into the php after closing it, setting the content type disposition...

however, I wonder: is it possible to create the db directly in php without ACTUALLY CREATING ALL THE SQL INSERTS ETC...

I am reading info from a database, specific to a user, and dumping this information into a sql database. then emailing it to a user... - as a user is logged in, i want to allow them to download it from their members area on their own...


I currently....

(mysql connect...
$ffdb = new sqlite....

create sqllite table...

select from mysql
foreach - insert into sqllite..

.. now, is it possible to just print / echo out the results, and bypass the creation of the db... im only deleting it anyway...

if so, could you help with some code?

cheers