Complex query help

[gmc1103]

Hi

 

I would like some help with this query, the purpose is when someone make an activity , after the date he must define if that activity has been done or not, and i want to put an alert until those fields are registered into the database

The query is this one

SELECT COUNT( * ) AS total
FROM  `nem_pae_atividades` 
WHERE  `idutilizador` =1355
AND  `data` >= CURDATE( ) 
AND  `realizado` IS NULL 
OR LENGTH(  `realizado` ) =0

But i have  always 1 because of the last "and", how can i fix this??

[Barand]

When mixing AND and OR always use ( )'s to define your logic. For example

 

A AND B OR C

 

Do you mean

(A AND B) OR C

 

or

A AND (B OR C)

[gmc1103]

Hi Barand

 

Thank you, iv'e tried the way you told me with no success

 

This is what i have in my db

 

 

So my point is the make the owner change the field "realizado" if the "data" has been reached

 

My last query was

SELECT COUNT( * ) AS total
FROM  `nem_pae_atividades` 
WHERE (
 `idutilizador` =1355
AND  `data` >= CURDATE( )
)
OR (
 `realizado` IS NULL 
OR LENGTH(  `realizado` )
) =0

[Barand]

try

SELECT COUNT( * ) AS total
FROM  `nem_pae_atividades` 
WHERE 
  `idutilizador` =1355
AND  
  `data` <= CURDATE( )
AND (
 `realizado` IS NULL 
  OR LENGTH(  `realizado` )=0
)