mssql_fetch_array() - Looping through Result Set Objects

Q

How To Loop through Result Set Objects using mssql_fetch_array()?

✍: Guest

A

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

⇑⇑ SQL Server Connection Tutorials

2024-03-23, 1247🔥, 0💬