My Query:
select id from clientes where cliente = '$cliente' AND status = '2' AND
(tipo <> '0' AND (disponibilidade <> '0' OR vanual <> '0' OR vtemporada <> '0'))
I need it to work as follows:
You may see some record if the TYPE field is other than ZERO and also at least one of the fields: availability , vanual and timesheet have some nonzero value.
In other words, to display a record the TYPE field is required to be different from ZERO and also some of the availability fields, > vanual and timeout have any non-zero value
Except that this SQL that I mounted does not do that!
I look forward to help!