www.webdeveloper.com
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Jan 2006
    Posts
    95

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

    Hey All,
    Is there a simple means by which to have this query run ONLY ONCE, per day?
    PHP Code:
    foreach ($targets as $key => $value) { 
    set_time_limit60 ); 
        
    $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);


  2. #2
    Join Date
    Nov 2006
    Posts
    16
    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.

  3. #3
    Join Date
    Jan 2006
    Posts
    95
    Thanks Iluxa,
    Yeah, it looks like cron job is about the only way.Grrrrr

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles