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, 1237🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...