DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) mysql_fetch_row

Info Catalog (mysql.info.gz) mysql_fetch_lengths (mysql.info.gz) C API functions (mysql.info.gz) mysql_field_count
 
 22.2.3.19 `mysql_fetch_row()'
 .............................
 
 `MYSQL_ROW mysql_fetch_row(MYSQL_RES *result)'
 
 Description
 ...........
 
 Retrieves the next row of a result set. When used after
 `mysql_store_result()', `mysql_fetch_row()' returns `NULL' when there
 are no more rows to retrieve.  When used after `mysql_use_result()',
 `mysql_fetch_row()' returns `NULL' when there are no more rows to
 retrieve or if an error occurred.
 
 The number of values in the row is given by `mysql_num_fields(result)'.
 If `row' holds the return value from a call to `mysql_fetch_row()',
 pointers to the values are accessed as `row[0]' to
 `row[mysql_num_fields(result)-1]'.  `NULL' values in the row are
 indicated by `NULL' pointers.
 
 The lengths of the field values in the row may be obtained by calling
 `mysql_fetch_lengths()'.  Empty fields and fields containing `NULL'
 both have length 0; you can distinguish these by checking the pointer
 for the field value.  If the pointer is `NULL', the field is `NULL';
 otherwise, the field is empty.
 
 Return Values
 .............
 
 A `MYSQL_ROW' structure for the next row.  `NULL' if there are no more
 rows to retrieve or if an error occurred.
 
 Errors
 ......
 
 Note that error is not reset between calls to `mysql_fetch_row()'
 
 `CR_SERVER_LOST'
      The connection to the server was lost during the query.
 
 `CR_UNKNOWN_ERROR'
      An unknown error occurred.
 
 Example
 .......
 
      MYSQL_ROW row;
      unsigned int num_fields;
      unsigned int i;
 
      num_fields = mysql_num_fields(result);
      while ((row = mysql_fetch_row(result)))
      {
         unsigned long *lengths;
         lengths = mysql_fetch_lengths(result);
         for(i = 0; i < num_fields; i++)
         {
             printf("[%.*s] ", (int) lengths[i], row[i] ? row[i] : "NULL");
         }
         printf("\n");
      }
 
Info Catalog (mysql.info.gz) mysql_fetch_lengths (mysql.info.gz) C API functions (mysql.info.gz) mysql_field_count
automatically generated byinfo2html