[RESOLVED] Run Query One time only(per day?)

[tjmcd]

Hey All,
Is there a simple means by which to have this query run ONLY ONCE, per day?

foreach ($targets as $key => $value) { 
set_time_limit( 60 * 5 ); 
    $populate_canvas_list = "INSERT INTO prospect_lists_prospects (id,prospect_list_id,related_id,related_type,date_modified,deleted) 
        VALUES $value);"; 
            $result=mysql_query($populate_canvas_list);
} 

[iluxa]

You can do that outside of PHP. Alternatively, if you really want to do it in PHP
use PHP CLI version, and run that from cron (presuming you are on Unix),
if you are on windows, use "at" to schedule the job.

[tjmcd]

Thanks Iluxa,
Yeah, it looks like cron job is about the only way.Grrrrr