Mailing new matches for search on a update

Hi,

I am pritty new to mysql but I was wondering how to go about on a question I have.

If a registered member performs a search I want to be able to store that search and on updates if there is a new matching record to mail him/her automaticaly.
What is the best way to do this?

Edwin

if your "users" table has a "user_id" create a table that stores the "query" and user_id".

then when you run a script to mail updates loop thru the "users" and select the queries using the "user_id", then loop thru the queries and include them in the output to the mail handle.

you might want to make storage of the queries conditional, ie. let the user select whether they wish to receive all this info in their update email...

HTH
marty