Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'NULL' != NULL
- ...
- <option value='todos'>Todos</option>
- ....
- ...
- AND tipo_venda IS NULL AND tipo IS NULL
- ...
- $WHERE = array();
- if( $_GET['tipo_pagamento'] != "null" ) // so coloca se nao for null
- array_push($WHERE,"tipo='$_GET['tipo_pagamento']'");
- if( $_GET['tipo_vendas'] != "null" ) // so coloca se nao for null
- array_push($WHERE,"tipo_venda ='$_GET['tipo_pagamento']'");
- $WHERE = count($WHERE) ? "AND ".join($WHERE," AND ") : "";
- $qry = "SELECT * FROM vendas WHERE DATE(date_created) = '2018-12-12' {$WHERE} ORDER BY 'id'"
- print $qry;
Add Comment
Please, Sign In to add comment