//make connection with mysql and select the database $mysql_connect = mysql_connect($host, $mysql_user, $mysql_password) ; if(!$mysql_connect) {echo ("<P>Connection issues. No results displayed.</P>");} $db_select = mysql_select_db($mysql_db); if(!$db_select) {echo ("<P>Connection issues. No results displayed.</P>");} $subject = "Subject Text"; $body = "Body text; $event_date = '2015-01-31'; //Y-m-d FORMAT
but I would also like to put into the email at the beginning: Hi first_name, (with the comma and then a couple of line spaces within the $body) In the mysql the first name is listed as first_name, so I would want the email to automatically insert the recipients first name at the beginning, at the top of the email. How do you do that please? Dez.