PDA

View Full Version : database update notification?



pghcollectibles
05-03-2008, 11:11 AM
instead of putting code into my page after the code: INSERT into...
is located, is there a way for me to be notified or preferably to run some other code or something when a table gets modified? did that make sense?

im trying to figure out a way to automate part of my ordering so i wouldnt have to check in on my page or my email really. i dont exactly want to tell my customers "ill be back in a week" if i ever want to take a vacation

pghcollectibles
05-03-2008, 11:23 AM
i guess this sounds like a cron job. should i have it do a query select and count row numbers or something? i would need to be able to update the number of rows its comparing to ie:

if ($number_of_rows>$value)

im not sure how get a value (maybe from a text file) then make that value = $value, update it if necessary, then resave.

i quess it would involve that kind of a task? how do i do it?

pghcollectibles
05-03-2008, 01:59 PM
lets say ive figured out some code to update the value, the file (file.php lets say) is in my root folder, when i go to cron jobs:

what do i put on the command line? is this correct: /usr/bin/php -q /home/user/folder/file.php
whats the first part of the code mean? are those server folders higher up

what is the cron output that they are sending to my email are they talking about what you would see if you opened it in a browser