Running a query and reading into Database

[ehask]

I have an app that managers will need to export Sales Reps sales from a Mysql DB into ACT!. I tried to use 'INTO OUTFILE' but get Denied so I am trying to figure out how to read multiple rows of data from a query into a Tab Delimited Txt file.

I dont know how to loop the query results into the file. Does anyone have any samples I could look at?

This is going to be on a proprietary intranet server so my other thought is when I set up MySQL on it to run as root and that will fix my OUTFILE issue.

I would rather learn how to read query results into a file as I think it would be a better solution

Thanks,

Eric
Rackspeed.net

[drawmack]

$of = fopen("Filename.txt",'w') or die("could not open outfile");
while ($row = @mysql_fetch_row) {
    $line = implode("\t",$row) . "\n";
    fwrite($of,$line);
} //end while
fclose($of);