Ghawar Professeur F. | Bonjour,
si je fais ceci:
Code :
$serverName = "xxx"; $connectionOptions = array("Database"=> "xxx", "UID"=> "xxx", "PWD"=> "xxx", "CharacterSet"=> "UTF-8" ); $conn = sqlsrv_connect( $serverName, $connectionOptions); if( $conn === false) die(sqlsrv_errors ()); $sql = "select top 10 * from clients"; $res = sqlsrv_query( $conn, $sql); while( $row = sqlsrv_fetch_array( $res, SQLSRV_FETCH_ASSOC)){ }
|
ca marche très bien.
Par contre si je fais ceci:
Code :
$serverName = "xxx"; $connectionOptions = array("Database"=> "xxx", "UID"=> "xxx", "PWD"=> "xxx", "CharacterSet"=> "UTF-8" ); $conn = sqlsrv_connect( $serverName, $connectionOptions); if( $conn === false) die(sqlsrv_errors ()); $sql = "use MADB;select top 10 * from clients"; $res = sqlsrv_query( $conn, $sql); while( $row = sqlsrv_fetch_array( $res, SQLSRV_FETCH_ASSOC)){ }
|
(j'ajoute juste "use MADB;" à ma query)
Ça ne me retourne rien ! comment ceci est-il possible ? |