I created something like mail box I want if I got new mail ,,,, email auto will send me email to tell you have new email ... like what we have in fourm ..
my code when somone use form to send me email (localy) to submit textarea
$id=$_GET['id'];
$receiver =mysql_result(mysql_query("SELECT username FROM USERS WHERE id='".$_GET['id']."'"),0); //// here to get receiver username by his id when i enter to his profile
session_start();
$_SESSION["myusername"];
$sender=$_SESSION["myusername"]; //// to get sender username
$subj=$_POST['subj'];
$msg=$_POST['msg'];
$date=date("Y - F(n) - d / g:i a");
$result ="INSERT INTO mailbox (sender,receiver,subj,msg,date) VALUES ('$sender','$receiver','$subj','$msg','$date')";
$res=mysql_query($result);
..........
after that when receiver open his page he will see my msg.
when am sending to him how can i let submittion send email to him too
I have email filds in users table.
thanks in advance.