Outputting array to file

[emmahodd2]

I am having problems outputting an array to file. The array is the result of a query on my database.

Ideally I would like to create a CSV.

This is the code which I am currently at :-

if($fh)
  { 
// this section controls output
	$result2 = DBquery("SELECT * FROM tickets WHERE TicketID='$_POST[TicketID]'", $db);
	$row = DBfetch_array($result2);     

	$line = explode($row, "|");
	fwrite($fh, "Name: $line[0], Email: $line[1]");  		

//$content = serialize($row);  

//fwrite ($fh, $content);   			
         fclose($fh);  

       }

		

Any ideas would be really grateful. I can't seemm to find an example.

Emma

[maxpup979]

Your logic seems fine--and assuming that your functions work, your syntax seems OK. So where are you having problems?

[maxpup979]

OK...I didn't quite look at it closely enough--lets walk through this piece by piece.

First thing you want to do is get your data from the db--I assume that DBfetcharray returns an array of the results--

so you have:
$row = DBfetch_array($result2);
#next, format the text:
$line=$row[0].",".$row[1].",".$row[2];
#then you want to write it out to a file:
fwrite($fh,$line)

does that make more sense?