User sends request if request matches database send email

[a720]

I was wondering how we would do the following.

A user fills out a simple form requesting information about a car for example becuase the make and model is not listed in the database.

The user enters the make, model, color and mileage using a drop down menu. This gets stored to mysql.

When a model is added that is the same or is like what the user requested they automatically recieve an email telling them this.

I was wondering how you would do it. If anyone has some code snippets I would really appreciate it.

[barand]

See [man]mail[/man]

[herve]

Hi,

well, it's not just "code snippets" :-)
it's a whole prg you need there !

My 2 cents :

1) store the form values in a MySQL table
with the following columns :

make
model
color
mileage
email (of the requester)

(maybe also a "date of peremption" to avoid sending an email if the request is very old)

2) when someone INSERT a new ad in the database
check the table we have see in step 1

3) For every corresponding entries, send an email
with the mail() function for instance.

regards,
Hervé.