PHP : Increment date in mysql

**Warner** · 02-07-2009

Hello!

How can I update the value of a table field each time a page is viewed? I want to increment the value by one everytime the object is viewed. If there is a way of doing this can someone please point me in the right direction with regards to coding this? How do I setup my database/table to do that?

**Leonard23** · 02-07-2009

You can do the add strtotime by the no. of days you want ,

e.g.

Code:

 $today="2009-06-02";
 $nextday=strftime("%Y-%m-%d", strtotime("$today +1 day"));

**Hoobastank** · 02-07-2009

That's the only possible way I know of. Correct me if I'm wrong - but MySQL doesn't have inbuilt time based triggers.

Code:

mysql> SELECT something FROM tbl_name
    -> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;

For more help : check this

**SreeKanth** · 02-07-2009

You can try even this code :

Code:

'strConnection was initialized on the module
Dim adConnection as ADODB.Connection
Set adConnection = New ADODB.Connection
adConnection.ConnectionString = strConnection
adConnection.Open
adConnection.Execute "INSERT INTO persons(lastname, firstname, middlename) VALUES ('lastname','firstname','middlename')"
adConnection.Close