Returns lines number from a results set.
int i5_num_rows ( |
resource result/query ) |
Retrieves lines number in results set. This command is available only to SELECT requests or file opened with i5_open.
To retrieve lines number involved with an INSERT, UPDATE or DELETE request, use i5_affected_rows function.
result |
File or request ID |
Returns lines number in case of success or FALSE if it fails.
Error returned
I5_ERR_PHP_HDLDFT |
256 |
No default connection found. |
I5_ERR_PHP_OPTIONSTYPE |
259 |
The type of " I5_OPTIONS_ALIAS" option must be x and not x |
I5_ERR_PHP_OPTIONSNUMBER |
260 |
Option number -1 is unknown. |
$sql = 'SELECT CNOM, CVILLE FROM EASYCOM/P$CLIENT ORDER by CCODE ';
$result = i5_query($sql);
if (is_bool($result)) trigger_error("i5_query error : ".i5_errormsg(), E_USER_ERROR);
if ($result) {
/* Find out lines number in results set */
$nb_lines = i5_num_rows($result);
printf("Results set has %d lines.<BR>", $nb_lines);
$obj = i5_fetch_object($result);
printf("%s (%s)<BR>", $obj->CNOM, $obj->CVILLE);
}