#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Den Haag, ZH, Netherlands
    Posts
    1
    Rep Power
    0
    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
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    35
    Rep Power
    15
    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

Similar Threads

  1. Replies: 18
    Last Post: May 6th, 2004, 02:23 PM
  2. Limiting factor of update/insert performance
    By bcyde in forum PostgreSQL Help
    Replies: 12
    Last Post: February 26th, 2004, 03:14 PM
  3. sql update inserts '0' and not var
    By SeenGee in forum PHP Development
    Replies: 2
    Last Post: February 16th, 2004, 10:18 PM
  4. Can't UPDATE data base
    By icaam in forum PHP Development
    Replies: 8
    Last Post: February 1st, 2004, 11:29 PM
  5. update table data from md array
    By MikePeterson in forum MySQL Help
    Replies: 2
    Last Post: July 18th, 2003, 03:16 AM

IMN logo majestic logo threadwatch logo seochat tools logo