from SQL to .dat or ,txt

NZ_Kiwis

i have this code

	$db = mysql_connect($server, $username, $password) or die(mysql_error());
	      mysql_select_db($dbname) or die(mysql_error());

$sql = 'SELECT 
            c.country 
        FROM 
            ip2nationCountries c,
            ip2nation i 
        WHERE 
            i.ip < INET_ATON("'.$_SERVER['REMOTE_ADDR'].'") 
            AND 
            c.code = i.country 
        ORDER BY 
            i.ip DESC 
        LIMIT 0,1';

list($countryName) = mysql_fetch_row(mysql_query($sql));

// Output full country name
echo $countryName;

i don't want to use a sql database but would rather have a file like .dat or .txt can someone please convert it for me??????? please 😉

thorpe

can someone please convert it for me??????? please

you cant run sql queries on text files. what do you propose we do? i propose you leave it in a database, thats what they are made for.... storing and querying data.

NZ_Kiwis

I didn't want to add all the information to my db. I'm only going to use the information for a few months as a test. if i didn't continue with it i would jsut need to delete the files.

if information was in a .txt. .dat file how would i do this query then??

thorpe

it would meen looping through each line, breaking it into each part, then parsing all the parts into something usefull. take a look at the [man]fopen[/man] function for examples on reading files. honestly, this sort of thing is much easier done with a database. with a database, you let sql (structured query language) do all the work. in a flat file youve gotta do all the work yourself.