Dcount with Mysql query

[patrickstrijdonck]

Hi all,

I want to run a Mysql query that counts (with help of Dcount) the records that has been changed in the last 4 weeks, is this possible, if yes, can someone point me in the right directions??

 

[jpadie]

assuming that you have a column that tracks the last update time for the row

select count (*) as cnt where lastupdate_col_name > date_sub(curdate(), interval 4 week)

dcount is not a familiar term to me in php.

 

[jpadie]

oops

select count (*) as cnt [red] from tableName [/red] where lastupdate_col_name > date_sub(curdate(), interval 4 week)

 

[patrickstrijdonck]

oops, Dcount is from Visual Basic lol, sorry about that, Thanks for the tip, Now what i want is to echo the result, how can i show the result??