...

View Full Version : Email alerts



preacher28
08-25-2004, 11:14 AM
Hi guys,

I am building a database for a recruitment site. Everything is going great. Admin section is nearly there. Searching the database is finished, but the client has just asked me if it was possible to set it up so a user can enter his/her email address and the kind of job they are interested in. When the client enters a new job, if it matches what someone is looking for eg Business, there will be an automatic email alert to that person. Kinda like here http://www.daft.ie/emailalerts.daft

I have no idea how to do this. Any suggestions/apps out there?

Thanks in advance.

A1ien51
08-25-2004, 01:23 PM
Basically you need a database with the search paramters, when you add the job, you need to loop through the table and see if anny of them match keywords in the new posting. Then send out an email if there is a match.


What part are you not sure about?

Eric

preacher28
08-25-2004, 04:31 PM
This bit here:

"you need to loop through the table and see if anny of them match keywords in the new posting. Then send out an email if there is a match."


How do i go about doing this?

A1ien51
08-25-2004, 05:00 PM
All it is a sql query and you need to loop through all of the results..

http://www.codeave.com/asp/code.asp?u_log=56

shows how to write a table from a query.


Instead of writing a table, you want to use a email script to send out emails.

Eric

preacher28
08-25-2004, 07:11 PM
Thank you. I will try and see if I can get that working.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum