php current_date

[tao]

Hi, I meet some problem in debugging php files.

this is the one running smoothly

[code=php]$query = "select account.id as account_id from account
where (date(creationd ate)=date(curre nt_date-interval '1 days') or account.status= 'DELETED');[/code]

but when I changed the condition to:
[code=php]if ($result_array['creationdate'] != date(current_da te-interval '1 days'))
{
//do something
}[/code]

[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:
[code=php]
if ($result_array['creationdate'] != date('+1 day'))
[/code]

[tao]

still doesn't work...

can someone help again?

Heya, tao. Welcome to TSDN!

PHP works a little differently than MySQL. Try this instead:
[code=php]
if ($result_array['creationdate'] != date('+1 day'))
[/code]

[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():
[code=php]
$yesterday = strtotime('-1 day');
[/code]