Results 1 to 3 of 3

Thread: mysql auto change data

  1. #1
    Join Date
    Oct 2010
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default mysql auto change data

    i have a database what shows data in php and on sertion days i want some to go from active=no to active=yes so it shows the info in my php page is their anyway to make the mysql database do it its self?

    thanks in advance
    Last edited by thedarkloki; 10-11-2010 at 12:41 PM.

  2. #2
    Join Date
    Oct 2008
    Posts
    60
    Thanks
    2
    Thanked 7 Times in 7 Posts

    Default

    As far as i know, no. But i could be wrong. Why dont you just use the "UPDATE" statement and update the yes or no.

  3. #3
    Join Date
    Sep 2008
    Location
    Bristol - UK
    Posts
    842
    Thanks
    32
    Thanked 132 Times in 131 Posts

    Default

    You will need a cron job to do this. You can write a script that will check / update the database as you want, which you can then run at whatever times you want.

    Ask your host about cron jobs, they'll be able to tell you if it's possible with your current setup.

Bookmarks

Posting Permissions

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