email_log

gistfile1.aw

function store_in_msg_table($message){
  $message = mysql_real_escape_string($message);
  openconn();
	$sql = '';
	if(!mysql_num_rows( mysql_query("SHOW TABLES LIKE 'email_store'"))){
		$sql = "CREATE TABLE  'email_store' ('id' INT NOT NULL AUTO_INCREMENT PRIMARY KEY , 'message' TEXT NOT NULL , 'date_sent' TIMESTAMP NOT NULL);";
		mysql_query($sql) or die(mysql_error());
	}
	$sql = 'INSERT INTO email_store (message) values ("'.$message.'");';
	mysql_query($sql) or die(mysql_error());
}