Page 1 of 1

Query/Parse a Flat-File DB

Posted: Tue Apr 15, 2003 2:31 pm
by Bungholio
Hi, just wondering about queryin or parsing a flat file db. i did a search in the forums, but didnt see anything...

anyways, the db is fairly large, and the lines of data are like this

company|COUNTRY|version|xxx.xxx.xxx.xxx|1111|222222|type

now the Country is Abbr to US or CA for example. also the xxx.xxx, incase you didnt know is an ip. also the length and values of 1111 & 2222 can vary from 0 to whatever. the 'company' 'version' & 'type are just different strings.

again its a pretty big DB, and ive got a bit of experience with PHP and mySQL DB's, but i dunno if this is the same or what?

can anyone tell me if theyve seen any tuts, or if you know how to query this type of db, etc..

thanks a bunch,
Allan

Posted: Fri Apr 18, 2003 4:35 pm
by AlphaWolf
This might get you going in the right direction...

http://www.php.net/manual/sk/function.fscanf.php