php current_date

[tao]

Hi, I meet some problem in debugging php files.

this is the one running smoothly

$query = "select account.id as account_id    from account
        where (date(creationdate)=date(current_date-interval '1 days') or account.status='DELETED');

but when I changed the condition to:

if ($result_array['creationdate'] != date(current_date-interval '1 days'))
    {
//do something
}

[Please use CODE tags when posting source code. Thanks! --pbmods]

there is parse error for '1 days'

parse error, unexpected T_CONSTANT_ENCA PSED_STRING


can anyone throw some idea??

Thank you

[pbmods]

Heya, tao. Welcome to TSDN!

PHP works a little differently than MySQL. Try this instead:

if ($result_array['creationdate'] != date('+1 day'))
 

[tao]

still doesn't work...

can someone help again?

Heya, tao. Welcome to TSDN!

PHP works a little differently than MySQL. Try this instead:

if ($result_array['creationdate'] != date('+1 day'))
 

[code green]

You are trying to compare a DATE field to a string [PHP]if ($result_array['creationdate'] != date(current_da te-interval '1 days'))[/PHP] At the same time you are trying to pass a mathematical result and a string with no concatenation to date().
What is it you are trying to achive? The following is not very helpful

still doesn't work...

[tao]

the data type of current_date is DATE, so I am not comparing a DATE to a string.....

I am trying to get the value of yesterday by (current_date-interval '1 days') in php.

You are trying to compare a DATE field to a string [PHP]if ($result_array['creationdate'] != date(current_da te-interval '1 days'))[/PHP] At the same time you are trying to pass a mathematical result and a string with no concatenation to date().
What is it you are trying to achive? The following is not very helpful

[pbmods]

Heya, tao.

the data type of current_date is DATE, so I am not comparing a DATE to a string.....

I am trying to get the value of yesterday by (current_date-interval '1 days') in php.

MySQL may store the value as a date, but it fetches it as a string. To compare it to another date, you must first convert it into a timestamp by using strtotime().

To get yesterday's date, you will also need to use strtotime():

$yesterday = strtotime('-1 day');