[RESOLVED] how to output results of a select to text file???

[helloise]

i have a php script:

$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");

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???

[Undrium]

You are writing the SQL-string to the file, not the result.

I'd suggest you replace:

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

with

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

just to see how mysql_result() works. It is a very useful function when it comes to displaying queries.

http://php.net/manual/en/function.mysql-result.php