J
|
Jane 11/25/2008 |
Mary, global $conn; $strUpdate = "update pedigrees set SireID=ID where isnull(SireID)"; db_exec($strUpdate,$conn); |
|
501335 11/25/2008 |
Mary, You need to use external scheduler like CRON for this purpose. Write a script that checks the values and update records in the database. Use cron to run this script on timely fashion i.e. once a day. Here is just a sample:
|
J
|
Jane 11/26/2008 |
Hi, |
|
501336 11/26/2008 |
Hi, I'm not sure that I understand your code. You don't need to join tables. Cron is the name of program that enables unix users to execute commands or scripts automatically at a specified time/date. If you want to update database manually just open required page with your script when you want to update database.
|
J
|
Jane 11/27/2008 |
Hi, |