So I have a content management site set up, but I'm stuck on one part. I have a query
. I'm a beginner in PHP and SQL. Basically I need the query to run, it will come out with one result and I need that to be where the email is sent to. This is the existing code I have for sending out the email
Select `email` FROM author WHERE author.id IN(SELECT authorid FROM job WHERE id = '$_POST[id]')
Thanks in Advance!
$subject = " Job Application Confirmation";
$message = "Hello $_POST[name] , \r\rYou, or someone using your email address, has applied for the job: $text Using the Resource Locator at Prahan.com. Keep this as future reference. \r\r Full Name: $_POST[name] \r Location: $_POST[location] \r Email: $_POST[email] \r Additional Information: $_POST[info] \r Job ID: $id \r Job Name: $text \r \r Expect a response shortly. \r\r Regards, Prahan.com Team";
$headers = 'From: Prahan.com Team <firstname.lastname@example.org>';
'Reply-To: email@example.com' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
$to1 = 'firstname.lastname@example.org';
mail($to1, $result, $message, $headers);