53,7 → 53,7 |
} |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '. |
' num_nom, nom_sci '. |
'FROM fournier_v1_00 '. |
'FROM bdtfx_v1_01 '. |
'WHERE num_nom = num_nom_retenu '. |
implode(' AND ', $conditions). |
'ORDER BY nom_sci ASC '. |
79,7 → 79,7 |
} |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '. |
' num_nom, nom_sci, num_nom_retenu '. |
'FROM fournier_v1_00 '. |
'FROM bdtfx_v1_01 '. |
'WHERE num_nom = num_nom_retenu '. |
implode(' AND ', $conditions). |
'ORDER BY nom_sci ASC '. |
93,7 → 93,7 |
$masque = $this->parametres->getMasquePourBdd(); |
$requete = 'SELECT SQL_CALC_FOUND_ROWS '. |
' num_nom, nom_sci, num_nom_retenu '. |
'FROM fournier_v1_00 '. |
'FROM bdtfx_v1_01 '. |
'WHERE num_nom = num_nom_retenu '. |
($masque ? 'AND '. |
" (SOUNDEX(nom_sci) = SOUNDEX($masque)) ". |