sqlsrv-has-rows.md

title	sqlsrv_has_rows
description	sqlsrv_has_rows
author	David-Engel
ms.author	davidengel
ms.date	01/19/2017
ms.service	sql
ms.subservice	connectivity
ms.topic	reference
helpviewer_keywords	API Reference, sqlsrv_has_rows sqlsrv_has_rows

sqlsrv_has_rows

[!INCLUDEDriver_PHP_Download]

Indicates if the result set has one or more rows.

Syntax

  
sqlsrv_has_rows( resource $stmt )  

Parameters

$stmt: The executed statement.

Return Value

If there are rows in the result set, the return value will be true. If there are no rows, or if the function call fails, the return value will be false.

Example

<?php  
   $server = "server_name";  
   $conn = sqlsrv_connect( $server, array( 'Database' => 'Northwind' ) );  
  
   $stmt = sqlsrv_query( $conn, "select * from orders where CustomerID = 'VINET'" , array());  
  
   if ($stmt !== NULL) {  
      $rows = sqlsrv_has_rows( $stmt );  
  
      if ($rows === true)  
         echo "\nthere are rows\n";  
      else   
         echo "\nno rows\n";  
   }  
?>  

See Also

SQLSRV Driver API Reference