Results 1 to 3 of 3
October 3rd, 2010, 11:17 AM #112Registered User
How to use result of query as a variable?
So I have a content management site set up, but I'm stuck on one part. I have a queryCode:
Select `email` FROM author WHERE author.id IN(SELECT authorid FROM job WHERE id = '$_POST[id]')PHP Code:
$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 <email@example.com>';
'Reply-To: firstname.lastname@example.org' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
$to1 = 'email@example.com';
mail($to1, $result, $message, $headers);
October 3rd, 2010, 03:13 PM #2
Can you give a little more information?
I understand you are trying to send an email, but will this be after a user fills out a form or what?
October 3rd, 2010, 06:32 PM #312Registered User
My application is running here: http://prahan.com/jobs/jobs.php