Mysql Insert

duny

when i have members sign up i want to insert this in to the database e-post. I am wondering how i can do this.

if ($login ==""){
echo "";
}else {
$db_conn = mysql_connect("some.com", "$user", "$pass") or die("unable to connect to the database");
mysql_select_db("$db", $db_conn) or die("unable to select the database");
$send = "INSERT INTO e_post (id,groupname,login,whofrom,date,time,readstate,subject,message) VALUES ('','member','$login','MDD Admin','$date','$time','','Welcome to The MDD','$messg')";
$sent = mysql_query($send, $db_conn) or die("Query send failed".mysql_error());
}

can some one show me how to do this.
basically when a user sign up want to insert this in the database.

wendymelon

if ($login ==""){ 
echo ""; 
}else { 
$db_conn = mysql_connect("some.com", "$user", "$pass") or die("unable to connect to the database"); 
mysql_select_db("$db", $db_conn) or die("unable to select the database"); 
$send = "INSERT INTO e_post  (id,groupname,login,whofrom,date,time,readstate,su
bject,message) VALUES ('','member','".$login."','MDD Admin','".$date."','".$time."','','Welcome to The MDD','".$messg."');";
$sent = mysql_query($send) or die("Query send failed".mysql_error()); 
}