dieyana

hye...

i have some problem with mySQLite database.i have this code for my application.when you clik the load button,it will load a text file on the desktop directory.when you click the filter function it will split the text file according to an array that i have specified.
the text file consist of some data like this:66.249.71.54 - - [10/Oct/2008:03:31:01 +0800] "GET /mod.php?_call=Kalendar&day=2014-05-09 HTTP/1.1" 200
66.249.71.54 - - [10/Oct/2008:03:31:57 +0800] "GET /KERIAN%20ENG/Towns/Main_Town.htm HTTP/1.0" 404
i have created my database on my desktop using one tool that i have downloaded and point to that database.-the code here.
the problem now is,i want to store the "200" only strings into the database.strings other than "200" will be not stored in the database.can u show me how to do this..

i hope you can understand what i want...

thanks for your time..

//code for my application//
<?xml version="1.0" encoding="utf-8"?>

//code for mySQL//
<?xml version="1.0" encoding="utf-8"?>

ok..i have created my database.so you can ignore my first reply.=)

my problem now is,i have created one database on my desktop using one SQLite administration tool that i have downloaded.can you show me how to connect my database with my application that i have build using flex(AIR Application).i don't ave any idea how to do it

hye...this is great!!i have been searching about SQLite and Adobe AIR but nothing fulfill my needs.thank you so much to you.but could you write more about this??on how to create database,insert the data,query and retrieve data from the SQLite for Flex application.what u have posted is on Php.that would be great.

thanks in advance..