CODEWITHSUNDEEP
phpmysql
charlie_cat
charlie_cat

Reputation: 1850

how to write result set from select to txt file?

i have the following:

$sql5 = "select *,count(*) from rc_language_type_assoc_table group by language_type_id";
$result5 = mysql_query($sql5);                           //not correct
$count5 = mysql_num_rows($result5);                      //not correct

$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");

fwrite($fh, $sql5."\n");

$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");

fwrite($fh, $result5."\n");

the above is not what i want, i want the actual result set of the select to print in my StatsFile how can i achieve this please???

Upvotes: 0

Views: 405

Answers (2)

bumperbox
bumperbox

Reputation: 10214

not the most efficient solution, but should give you an idea of how to do the job

$sql5 = "select *,count(*) from rc_language_type_assoc_table group by language_type_id";
$result5 = mysql_query($sql5);                           //not correct
$count5 = mysql_num_rows($result5);                      //not correct

$myFile = "/home/rainbowcode/StatsFile.txt";
$fh = fopen($myFile, 'w') or die("can't open file");

fwrite($fh, $sql5."\n");

while ($row = mysql_fetch_assoc($result5) {
    foreach ($row as $key => $val) {
        fwrite($fh, "$key=>$val ");
    }

    fwrite($fh, "\n");
}

fclose($fh);

Upvotes: 3

Twelve47
Twelve47

Reputation: 3982

You need to fetch each row and then write the values for that row to the file.

Upvotes: 0

Related Questions