263,12 → 263,12 |
); |
$req = sprintf( |
'SELECT %s, group_concat(num_taxon) as num_taxon, IF(num_statut="",1,0) AS is_null' . |
' FROM %s WHERE %s GROUP BY id ORDER BY is_null ASC, num_statut ASC, %s %s -- %s:%d', |
' FROM %s WHERE %s GROUP BY id ORDER BY is_null ASC, num_statut ASC %s %s -- %s:%d', |
|
in_array('*', $this->requete_champ) ? ' * ' : implode(', ', $this->requete_champ), |
$this->table, |
$this->requete_condition ? implode(' AND ', $this->requete_condition) : 'TRUE', |
$this->tri ? ($this->tri . ' ' . $this->tri_ordre . ' ') : '', |
$this->tri ? (', '.$this->tri . ' ' . $this->tri_ordre . ' ') : '', |
$limiteClause, |
__FILE__, __LINE__); |
return $req; |
290,12 → 290,12 |
} |
$req = sprintf( |
'SELECT %s, IF(num_statut="",1,0) AS is_null' . |
' FROM %s WHERE %s ORDER BY is_null ASC, num_statut ASC, %s %s -- %s:%d', |
' FROM %s WHERE %s ORDER BY is_null ASC, num_statut ASC %s %s -- %s:%d', |
|
in_array('*', $this->requete_champ) ? ' * ' : implode(', ', $this->requete_champ), |
$this->table, |
$this->requete_condition ? implode(' AND ', $this->requete_condition) : 'TRUE', |
$this->tri ? ($this->tri . ' ' . $this->tri_ordre . ' ') : '', |
$this->tri ? (', '.$this->tri . ' ' . $this->tri_ordre . ' ') : '', |
$nolimit ? '' : $limiteClause, |
__FILE__, __LINE__); |
return $req; |