Trying to add a Header for CSV file...

[DisOrDeR1337]

Ok, I am trying to add a header for this... it creates an CSV file of name and e-mail so it can be imported by outlook... and is there anyway i can make this save as a text file, instead of no extension...

This is what I have...

if ($create) {

//create the file


$textfilename = date("dmY_is");
$fp = fopen("../filez/$textfilename", "w");



//read the content out of the database


$result = mysql_db_query ("$dbname","select * from $dbTable WHERE email LIKE '%@%' AND send = '1' ORDER BY email DESC");
$NumberOfFields=mysql_num_rows($result);

while ($row = mysql_fetch_array ($result)) {

	$email =$row["email"];
	$nname =$row["name"];
	$vname =$row["fname"];
	$UID =$row[UID];


	//$message = "$email"." "."$vname"." "."$nname"." "."$UID\n";
	$message = "$vname $nname,$email\n";

///////////////////////////////////////////////
//write the content strings into the textfile//
///////////////////////////////////////////////
	if($email) {
		fwrite ($fp,$message);
	}
}
fclose ($fp);
chmod ("../filez/$textfilename", 0777);

mysql_free_result($result);

}

[sarahk]

could it be as simple as...

$textfilename .= '.txt';
$fp = fopen('../filez/$textfilename', 'w'); 

[DisOrDeR1337]

Ok I can work with that for a filename thanks!

ok, now one more question....

right here

///////////////////////////////////////////////
//write the content strings into the textfile//
///////////////////////////////////////////////
if($email) {
fwrite ($fp,$message);
}
}
fclose ($fp);
chmod ("../filez/$textfilename", 0777);

mysql_free_result($result);
}

Now you see the

fwrite ($fp,$message);

that just writes the message, which is a query from the database.
is there anyway i can just add a line above where it starts writing?

all i want it to say is
Name, E-Mail Address

I cant figure out how to get it to do that..

[DisOrDeR1337]

im trying something like this...

but its not working, its just writing blank to the file

////////////////////////////////////////
//read the content out of the database//
////////////////////////////////////////

$result = mysql_db_query ("$dbname","select * from $dbTable WHERE email LIKE '%@%' AND send = '1' ORDER BY email DESC");
$NumberOfFields=mysql_num_rows($result);

while ($row = mysql_fetch_array ($result)) {

	$email =$row["email"];
	$nname =$row["name"];
	$vname =$row["fname"];
	$UID =$row[UID];


	//$message = "$email"." "."$vname"." "."$nname"." "."$UID\n";
	$head = "Name,E-mail Address\n";
	$message = "$vname $nname,$email\n";

///////////////////////////////////////////////
//write the content strings into the textfile//
///////////////////////////////////////////////
	if($email) {
		fwrite ($fp,$head,$message);
	}
}
fclose ($fp);
chmod ("../filez/$textfilename", 0777);

mysql_free_result($result);

}

[sarahk]

try

//////////////////////////////////////// 
//read the content out of the database// 
//////////////////////////////////////// 

$result = mysql_db_query ("$dbname","select * from $dbTable WHERE email LIKE '%@%' AND send = '1' ORDER BY email DESC"); 
$numRows=mysql_num_rows($result); 

if ($numRows > 0)   fwrite ($fp,"Name,E-mail Address\n"); 

while ($row = mysql_fetch_array ($result)) 
{ 
  //  $UID =$row[UID]; 

  //true csv has quotes and commas
  //$message = "\"{$row['fname']} {$row['name']}\",\"{$row['email']}\"\n"; 
  $message = "{$row['fname']} {$row['name']},{$row['email']}\n"; 
  /////////////////////////////////////////////// 
  //write the content strings into the textfile// 
  /////////////////////////////////////////////// 
  fwrite ($fp,$message); 
} //while
fclose ($fp); 
chmod ("../filez/$textfilename", 0777); 

mysql_free_result($result); 
}

[DisOrDeR1337]

howd you color coordinate it?
heh, thats awesome...

and it worked, thank you sooooo much

ill pm you and show you how its workin so far...

[sarahk]

click on the php button above the reply box and enter your code. it's basically using the html tags theory but using square brackets rather than the greater than, less than.

The good things are
preserves formatting, indents
color codes
* easier to spot mistakes in suggestions, especially since most aren't tested

[DisOrDeR1337]

awesome thanks!

aaron

ill pm you that link so you can check it out