PROS! Running a script?? (Easy)

[brianb]

Hello pros,

I have an UPDATER script wich includes 2 other scripts inside of it's programming, it runs off of a bunch of functions etc etc etc...

Each entry in my database has an ID number that the UPDATER SCRIPT needs to run, as it tells the other scripts how to get the info.

What I'd like to do is take all the data stored in my database and list EVERY entry's ID number. I've done this....

Now, I'd like to run the UPDATER SCRIPT against each ID number in the database, one by one, waiting about 20 seconds in between each run of the UPDATER.

How would you guys suggest doing this? Obviously I have to create a new little script that will run the UPDATER against each ID number, but I don't know how to do this. Any suggestions?

[Weedpacket]

If the updater script file has functions, split them out into a sepate support file.

1. Get your IDs into an array.

2. Include the support file with the updater script's functions.

3. Loop through the array for each ID:

4. Include the updater script itself

5. sleep 20 seconds

6. Loop

You'll want to stick a set_time_limit() in there, probably between steps 3 and 4. Or calculate, say, 21*(the number of IDs), and set your time limit to that between steps 2 and 3.

I can think of other methods (write the IDS to a temp file which gets eaten one line at a time by an update script that runs via cron job - but that means a script running every 20 seconds even if there's nothing for it to do) - it depends on what you're actually trying to do.

And why do you always want PROS! to help? Don't you think there are any competent amateurs out there?