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

[silkfire]

Remember that what you get from a MySQL select query is a MySQL resource that only PHP can interact with.

 

Loop through the result set and add everything into a variable and separate your values somehow.

 

Then save that variable to the file.

[helloise]

please can you help me with this? i have no idea on how to do this? i am new to php

 

thanks

[silkfire]

I need to know the database structure or at least what it is you're getting in return from the query.

[helloise]

thank you very much but i have the answer