Posted by applegreenss on 12/12/06 00:05

Is it possible to take the contents of a MySQL DB Table, and somehow
put the data into a syntax-correct data file format like a delimited
..txt file, and using PHP parse it as a local c:\ file assuming it was
sitting in C:\data.txt ..... so I want to read its contents in a
similar method as you would query a DB table .... can you do this the
same with a blob of data stored in a .TXT file?

If so, how to format .txt & php code -- I would very much like to
emulate this scenario against a c:\ stored .txt file:

<?
$sql_query = "SELECT * FROM localfile WHERE value = '$somevalue'";
$result = @mysql_query($sql_query,$db);

// now put all the data into arrays
$a = 0;
while ($row = mysql_fetch_row($result)) {

$somearray1[$a] = $row[0];
$somearray2[$a] = $row[1];

$a++;
}
?>

Can something like this be done? :)

• Next in forum: Re: Question about DB & accessing fixed records from local C:\ .txt file
• Prev in forum: Re: Flat file db. Only display records of unique field data.
• Thread view: Question about DB & accessing fixed records from local C:\ .txt file

[Reply to this message]