Subversion Repositories eFlore/Projets.eflore-projets

Compare Revisions

Ignore whitespace Rev 1243 → Rev 1244

/trunk/services/modules/0.1/nvjfl/NomsVernaculaires.php
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;