this is the one running smoothly
Expand|Select|Wrap|Line Numbers
- $query = "select account.id as account_id from account
- where (date(creationdate)=date(current_date-interval '1 days') or account.status='DELETED');
Expand|Select|Wrap|Line Numbers
- if ($result_array['creationdate'] != date(current_date-interval '1 days'))
- {
- //do something
- }
there is parse error for '1 days'
parse error, unexpected T_CONSTANT_ENCAPSED_STRING
can anyone throw some idea??
Thank you