new line in file writing

[d99kg]

i am writing to a .data file

how do i take a new line

\n doesn't seen to work

[epimeth]

\r\n

[d99kg]

Will u look at what is wrong with this! I asked u about the mail function yesterday, I keep getting bad printed to the screen

<?php

if($submit)
{
$db = mysql_connect("localhost", "d99kg", "password");
mysql_select_db("d99kg",$db);
$dbQuery="SELECT * FROM users where username='$theusername'";
$result = mysql_query($dbQuery,$db);

$userInfo=mysql_fetch_array($result);
$username=$userInfo["username"];
$password=$userInfo["password"];
$userFunctions=$userInfo["userFunctions"];
$firstName=$userInfo["firstName"];
$lastName=$userInfo["lastName"];
$emailAddress=$userInfo["emailAddress"];

$mailsubject = "Your password";
$mailbody = "Your Password is $password";

//if(mail($emailAddress, $mailsubject, $mailbody))
//{ echo "XXX good";
//}

$myname = "gk";
$myemail = "[e-mail]";

$message = "Your password is $password - Don't forget it again!";
$subject = "Your Password";

$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
$headers .= "From: ".$myname." <".$myemail.">\r\n";
$headers .= "To: ".$firstName.$lastName." <".$firstName.$lastName.">\r\n";
$headers .= "Reply-To: ".$myname." <$myreplyemail>\r\n";
$headers .= "X-Priority: 1\r\n";
$headers .= "X-MSMail-Priority: High\r\n";
$headers .= "X-Mailer: Just My Server";

if (mail($emailAddress, $subject, $message, $headers))
{
echo "Good";
}
else echo "Bad";

}

?>

Cheers

[epimeth]

please encode php in php tags like so:

if($submit) 
{ 
$db = mysql_connect("localhost", "d99kg", "password"); 
mysql_select_db("d99kg",$db); 
$dbQuery="SELECT * FROM users where username='$theusername'"; 
$result = mysql_query($dbQuery); 

$userInfo=mysql_fetch_assoc($result); 
$username=$userInfo["username"]; 
$password=$userInfo["password"]; 
$userFunctions=$userInfo["userFunctions"]; 
$firstName=$userInfo["firstName"]; 
$lastName=$userInfo["lastName"]; 
$emailAddress=$userInfo["emailAddress"]; 

$myname = "gk"; 
$myemail = "[e-mail]"; 

$message = "Your password is $password - Don't forget it again!"; 
$subject = "Your Password"; 

$headers = "MIME-Version: 1.0\r\n"; 
$headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; 
$headers .= "From: ".$myname." <".$myemail.">\r\n"; 
$headers .= "Reply-To: ".$myname." <$myreplyemail>\r\n"; 
$headers .= "X-Priority: 1\r\n"; 
$headers .= "X-MSMail-Priority: High\r\n"; 
$headers .= "X-Mailer: Just My Server"; 

if (mail($emailAddress, $subject, $message, $headers)) 
{ 
echo "Good"; 
} 
else echo "Bad"; 

} 

I'm assuming $submit is true.... and tested as such
also, $theusername is right?

mysql_query accepts one parameter, as such:
$result = mysql_query($dbQuery);

mysql_fetch_array() returns a numbered array. you want to use
$userInfo=mysql_fetch_assoc($result);
this will allow you to do $userinfo['username'] while otherwise you would have to do $userinfo[1].

$headers should already be initialized to "", otherwise I don't think .= would work...

got rid of To in the header... if you want it put it back, but add a space between firstname and lastname...

$myreplymail should be initialized... really if you're reply mail is the same as your from mail you don't need the reply-to header

I reckon it should work now...