Employers can get Resumes via Email

open
Topic Author
Offline
Junior Boarder

12 years 3 months ago #2353 by open

Replied by open on topic Employers can get Resumes via Email

Many thanks,
But I am not quite good in PHP codes, could you guide me changing what to what?

Super User
Offline
User is blocked

12 years 3 months ago #2354 by Super User

Replied by Super User on topic Employers can get Resumes via Email

Hi,

Replace this code

$jobquery = "SELECT users.name, users.email, job.title, job.sendemail FROM ".$db->nameQuote('#__users') ."AS users, ".$db->nameQuote('#__js_job_jobs') ." AS job  
		WHERE users.id = job.uid  AND job.id = ".$jobid;

With

$jobquery = "SELECT company.contactname AS name, company.contactemail AS email, job.title, job.sendemail 
			FROM ".$db->nameQuote('#__js_job_companies') ."AS comapney
			JOIN ".$db->nameQuote('#__js_job_jobs') ." AS job ON job.companyid = company.id  
			WHERE job.id = ".$jobid;

Best regards,

Ahmad Bilal

open
Topic Author
Offline
Junior Boarder

12 years 3 months ago #2356 by open

Replied by open on topic Employers can get Resumes via Email

I know that I bothered you, but it didn't work. any idea?

Super User
Offline
User is blocked

12 years 3 months ago #2358 by Super User

Replied by Super User on topic Employers can get Resumes via Email

Hi,

Please open a ticket.

Best regards,

Ahmad Bilal

tammys gordon
Offline
Fresh Boarder

12 years 5 days ago #2575 by tammys gordon

Replied by tammys gordon on topic Employers can get Resumes via Email

Hi Bilal,

Thanks for your Information, it helped me too. Once again thanks for your valuable info.

sample job descriptions

Jeffrey C Schork
Offline
Fresh Boarder

11 years 9 months ago #2657 by Jeffrey C Schork

Replied by Jeffrey C Schork on topic Employers can get Resumes via Email

When changing the code in jsjobs.php, is this "
function sendMail($jobid, $uid,$resumeid)" the new code or original?

Time to create page: 0.072 seconds