Hello, I have a table where I want to show only pending and resolved requests from the state field of my table in my DB.
$sql = "SELECT * FROM contribuyente WHERE estado ='Pendiente' AND
estado='Resuelto' ORDER BY id
Hello, I have a table where I want to show only pending and resolved requests from the state field of my table in my DB.
$sql = "SELECT * FROM contribuyente WHERE estado ='Pendiente' AND
estado='Resuelto' ORDER BY id
As conditionals are in the same field, you have to use the where in property, which allows me to query several conditions in a field
$sql = "SELECT * FROM contribuyente
WHERE estado in ('Pendiente','Resuelto') ORDER BY id