Collections:
mssql_fetch_array() - Looping through Result Set Objects
How To Loop through Result Set Objects using mssql_fetch_array()?
✍: Guest
If the returning output of a query statement is captured in a result set object, you can use mssql_fetch_array() to loop through each row in the output.
The tutorial PHP script below shows you how to list tables in the database:
<?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"); while ($row = mssql_fetch_array($res)) { print(" ".$row{'name'}."\n"); } mssql_free_result($res); mssql_close($con); ?>
If you run this script, you will get something like:
User Tables: fyi_rates fyi_team fyi_random fyi_links_indexed fyi_links fyi_links_copy tipBackup2
⇒ mssql_result() - Retrieve Field Values
⇐ Returning Result from Query with MSSQL Connection
⇑ SQL Server FAQs - PHP MSSQL Functions - Connections and Query Execution
2024-03-23, 1318🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...