function listeServices ()
				{
					global $ExODBC ;
					$Services = odbc_exec ( $ExODBC , "select * from Services order by CSA, l_Service" ) ;
					print ( "<option>\n" ) ;
					while ( odbc_fetch_row ( $Services ) )
					{
						$CSA = odbc_result ( $Services , "CSA" ) ;
						$CSB = odbc_result ( $Services , "CSB" ) ;
						$l_Service = odbc_result ( $Services , "l_Service" ) ;
						$id_Service = $CSA . $CSB ;
						$M_Service = odbc_exec ( $ExODBC , "select * from Services where CSA = '$CSA' and CSB = '00'" ) ;
						$l_M_Service = odbc_result ( $M_Service , "l_Service" ) ;
						print ( "<option value=\"$id_Service\">$l_Service ($id_Service)\n "  ) ;

voila mon souci j'ai cree la fonction
liste service suivante
[php]function listeServices ()
{
global $ExODBC ;
$Services = odbc_exec ( $ExODBC , "select * from Services order by CSA, l_Service" ) ;
print ( "<option>\n" ) ;
while ( odbc_fetch_row ( $Services ) )
{
$CSA = odbc_result ( $Services , "CSA" ) ;
$CSB = odbc_result ( $Services , "CSB" ) ;
$l_Service = odbc_result ( $Services , "l_Service" ) ;
$id_Service = $CSA . $CSB ;
$M_Service = odbc_exec ( $ExODBC , "select * from Services where CSA = '$CSA' and CSB = '00'" ) ;
$l_M_Service = odbc_result ( $M_Service , "l_Service" ) ;
print ( "<option value=\"$id_Service\">$l_Service ($id_Service)\n " ) ;[/php]


comme vous le voyez elle concataine les champ csa csb

cela me pose un probleme car je ne sais pas quel requete sql cree pour selectionner les info des champs contenant le numeros envoyer

quelqu'un voit comment faire?