0
I have the SQL:
select id,disponibilidade,tipo from clientes where cliente = '$cliente' AND status = '2' AND tipo = '0' OR disponibilidade <> '0' OR vanual <> '0' OR vtemporada <> '0'
You have to return record if the field guy is equal to zero and if all fields availability, vanual and vtemporada are zero. But... will not return record if the capo guy is different from zero and also if any of the fields like availability, vanual and vtemporada are different from zero.
But I can’t do it!
Possible duplicate of How to validate some fields in SQL
– Daniel Omine
Possible duplicate of I have a QUERY that doesn’t display what I really need
– Jéf Bueno