Hi, can anyone tell me what is the problem of my script: $sql2 = "SELECT * FROM Cash WHERE HP='$HP' and SignUpDate='$SignUpDate'"; $rows1 = mysql_query($sql2,$linkptr1) ; $OwnnerMail ="[EMAIL PROTECTED]"; $Subject = "Testing"; while ( $row = mysql_fetch_array($rows1) ) { $newvalue = $row["Password"]; echo "$newvalue\n"; } $Body = $newvalue; $From = "$HP"; mail( $OwnnerMail,$Subject, $Body, "From: $From");
I can see all the data for $newvalue in browser. But, when i receive email, i can only see the last data. can i know what is the problem? thank you. ------------------------------------------------- This mail sent through IMP: http://horde.org/imp/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]