Posts by Gisele • 51 points
3 posts
-
1
votes1
answer455
viewsQ: How to make a Count in Mysql using case or if?
I need to know how I can do a search in mysql to know how many documents I have to analyze with a condition that if the previous process is not released it cannot count. SELECT COUNT(`num`), CASE…
-
1
votes0
answers65
viewsQ: Filter php chebox
function parseMysqlQuery($array) { $output = ''; foreach( $array as $key => $value){ $output .= !$output ? " WHERE $table.$key " : " AND $table.$key"; $output .= ' IN ("' . implode('","', $value)…
-
3
votes1
answer392
viewsQ: Filter with chekbox mysql php
Could you help me as I would concatenate strings in this search, passing which table is right if it would be i or c? select i.nome from imovel i join cidade c where c.nome in ("Campo…