Collections:
mssql_result() - Retrieve Field Values
How To Retrieve Field Values using mssql_result()?
✍: Guest
Once the result set is captured in an object, you can think of it as a "table" with rows and columns (fields). You can use mssql_result() to retrieve the value of any given row and column (field) with this formats:
$value = mssql_result($res, $row, $column); #- $row is the row number, starting with 0 #- $column is the column number, starting with 0
The tutorial PHP script below shows you how to list tables in the database with multiple field values:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $sql = "SELECT * FROM sys.objects" . " WHERE type_desc='USER_TABLE'"; $res = mssql_query($sql, $con); print("User Tables:\n"); for ($i=0; $i<mssql_num_rows($res); $i++) { print(" ".mssql_result($res,$i,0)); print(", ".mssql_result($res,$i,1)); print(", ".mssql_result($res,$i,6)."\n"); } mssql_free_result($res); mssql_close($con); ?>
If you run this script, you will get something like:
User Tables: fyi_rates, 85575343, USER_TABLE fyi_team, 165575628, USER_TABLE fyi_random, 821577965, USER_TABLE fyi_links_indexed, 1061578820, USER_TABLE fyi_links, 1093578934, USER_TABLE fyi_links_copy, 1253579504, USER_TABLE tipBackup2, 2121058592, USER_TABLE
⇒ mssql_field_name() - Retrieve Field Names
⇐ mssql_fetch_array() - Looping through Result Set Objects
⇑ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
2024-03-23, 1239🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...