where com DAYOFYEAR()

[turok 0]

tento fazer um select comparando as datas e retorna um erro estranho:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

PHP [/tr][tr] select * from TABELA where and ( DAYOFYEAR ( CAMPO ) = DAYOFYEAR( NOW() ) ) # seleciona todas que pertencem ao dia de hoje [/tr]

[turok 0]

Retirei os "(" no começo e no fim de cada and e funcionou:

PHP [/tr][tr]SELECT * from TABELA

where

YEAR( CAMPO ) = YEAR(now())

and

MONTH ( CAMPO ) = MONTH ( now() )

and

DAYOFYEAR( CAMPO ) = DAYOFYEAR( now() )

[/tr]