timesteamp problem

Discussion in 'PHP' started by saad_sinpk, Oct 15, 2011.

0
  1. #1
    i have make full script form, etc, i want to add field in that forum some one choose end date and time in that field and this go in mysql database, when that time come it automatically update this column and change product visible to 0

    for example

    i have column in mysql db product visible = 1 and end time is 2011- 20 - 10 yyyy-dd-mm and time 12 am now what that time and date came it automatically update product visible = 0

    can u guys please help me out it's urgent please
     
    saad_sinpk, Oct 15, 2011 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    Where you read the record for that product, if the current timestamp is later than the one in the record, update the record to set "product visible" to 0, and leave without displaying the product.
     
    Rukbat, Oct 16, 2011 IP
  3. saad_sinpk

    saad_sinpk Peon

    Messages:
    85
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    yes i want that, and i want that it automatically update to 0 from 1 after current time past to record don't need to run the file can u please help me to created this code
     
    saad_sinpk, Oct 16, 2011 IP
  4. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #4
    The code is "Where you read the record for that product, if the current timestamp is later than the one in the record, update the record to set "product visible" to 0, and leave without displaying the product. ". Write it in whatever language you use on the site.

    Or find someone you trust enough to give the login and password for your site to download your files, modify what has to be modified and upload it again. This can't be done as "put the following lines into the code at this point", since exactly what has to be written, and where it has to go, depends entirely on the code you already have.
     
    Rukbat, Oct 16, 2011 IP