Here is the code I am trying to do
Code: Select all
$currentdate = date("Y-m-d H:i:s");Code: Select all
$query = "SELECT MSid,email,startdate,enddate,amount FROM payed_users WHERE enddate > $currentdate ORDER BY enddate asc";Alsoo when I output $currentdate I get something like this
2006-02-15 21:21:04 and in my DB for the row endate they are in the format of 2006-02-06 15:46:17
so what am I doing wrong