Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - PHP MSSQL - Returning Result Set Objects

By: FYIcenter.com

(Continued from previous topic...)

PHP MSSQL - What Is a Result Set Object Returned by mssql_query()?

A result set object is a logical representation of data rows returned by mssql_query() function on SELECT statements. Every result set object has an internal pointer used to identify the current row in the result set. Once you get a result set object, you can use the following functions to retrieve detail information:

  • mssql_free_result($res) - Closes this result set object.
  • mssql_num_rows($res) - Returns the number rows in the result set.
  • mssql_num_fields($res) - Returns the number fields in the result set.
  • mssql_fetch_row($res) - Returns an array contains the next row indexed by field positions. The internal pointer is moved to the next row too.
  • mssql_fetch_array($res) - Returns an array contains the next row indexed by field positions and field names. The internal pointer is moved to the next row too.
  • mssql_fetch_assoc($res) - Returns an array contains the next row indexed by field names. The internal pointer is moved to the next row too.
  • mssql_fetch_object($res) - Returns an object representing the next row. The internal pointer is moved to the next row too.
  • mssql_field_name($res, $i) - Returns the name of the field with the specified index.
  • mssql_field_type($res, $i) - Returns the data type of the field with the specified index.
  • mssql_field_len($res, $i) - Returns the data type size of the field with the specified index.

(Continued on next topic...)

  1. PHP MSSQL - How To Create a New Table?
  2. PHP MSSQL - How To Drop an Existing Table?
  3. PHP MSSQL - How To Insert Data into an Existing Table?
  4. PHP MSSQL - How To Make a Column Nullable?
  5. PHP MSSQL - How To Insert Data with NULL Values?
  6. PHP MSSQL - How To Insert Multiple Rows with a subquery?
  7. PHP MSSQL - How To Get the Number of Affected Rows?
  8. PHP MSSQL - What Is a Result Set Object Returned by mssql_query()?
  9. PHP MSSQL - How To Loop through Returning Rows?
  10. PHP MSSQL - How To Update Existing Rows in a Table?
  11. PHP MSSQL - How To Delete Existing Rows in a Table?
  12. PHP MSSQL - How To Include Text Values in SQL Statements?
  13. PHP MSSQL - How To Include Date and Time Values in SQL Statements?
  14. PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes?
  15. PHP MSSQL - How To Perform Key Word Search in Tables?
  16. PHP MSSQL - How To Query Multiple Tables Jointly?
  17. PHP MSSQL - How To Create an Identity Column?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...