August 6th, 2000, 09:53 AM
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?
August 7th, 2000, 10:31 PM
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...