Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

MYSQL Timestamp adding time

Name: BigShow
Date: September 30, 2009 at 13:03:42 Pacific
OS: Windows XP
CPU/Ram: pentium 4
Product: Dell / Lap top
Subcategory: PHP

Comment:

Hi Guys, I have a table with a timestamp (ts) and status field and I want to update it if todays date (when the script is run) is greater then or equal to two days or more. This is what I am trying to write in easy terms. UPDATE sale SET status=5 WHERE currenttime>=(ts + 2 days) && status=1 I know this can be done strickly with mysql. I am going to run this script once a day automatically but I need this query worked out. Any thoughts.

Reply:

try UPDATE sale SET status=5 WHERE NOW()>=DATE_ADD(ts, INTERVAL 2 DAY) AND status=1

0

error page

C n HTML

Summary: Here's my situation. I'm trying to run a php based web forum I'm using Apache HTTP server 2.0.51 with php 5.0.1 installed as a module and MYSQL 4.1.5 gamma release. I'm releativly new to the php and...

Summary: Now you need MySQL. Btw, did you install PHP5? I should tell you earlier that I'm not sure if phpBB will work on PHP5. Also, if you get the windows installer of PHP5 (the smallest download), you're go...

Summary: Michael, I think date() will use UNIX timestamp, so I'm not sure if putting a data with MySQL timestamp column type will work. I think it should be like this: date ("F j, Y", strtotime ($mysqltimestam...