So I'm in the final stages of finishing my project, and I am stumped on something. I figured there are enough PHP genii around here to give me a hand with this.

I am trying to output data from a table called data in mysql, to a tab delimited, text file. My problem is that the new line isn't being reflected. The tabs are, but no new lines

code:

---

            $q = "SHOW COLUMNS FROM ".TBL_DATA."";
            $result = $database->query($q);
            $i = 0;
            if (mysql_num_rows($result) > 0) {
            while ($row = mysql_fetch_assoc($result)) {
            $csv_output .= $row['Field']."\t";
            $i++;
            }
            }
            $csv_output .= "\n";
            $q2= "SELECT * FROM ".TBL_DATA." WHERE ListID = '$listingsort'";
            $values = $database->query($q2);
            while ($rowr = mysql_fetch_row($values)) {
            for ($j=0;$j<$i;$j++) {
            $csv_output .= $rowr[$j]."\t";
            }
            $csv_output .= "\n";
            }

            $filename = $file."_".date("Y-m-d_H-i",time());
            header("Content-type: application/octet-stream");
            header("Content-disposition: attachment" . date("Y-m-d") . ".txt");
            header( "Content-disposition: filename=".$filename.".txt");
            echo $csv_output;

---

Use \r\n instead of \n only if you want to open the file on Windows.

Damn... That would make a lot of sense
The simplest thing really. Thank you very much. I was going crazy with this.