Hi, I have the following php code in my confid file, which works great,
//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 underneath before the main body text)
In the mysql the first name is listed as first_name, so I would want the email to automatically insert the recipients first name. How do you do that please?