Menu
i am trying to retrieve fields from a database that will bring all rows where payment is either due within the next 7 days or overdue using the following code
[code=php]$week=time()+604800;
$week=date(“Y-m-d”,$week);
$query=mysql_query(“SELECT * FROM users WHERE paydate<=$week ORDER BY paydate DESC”);
but this doesnt work at all, any ideas