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?