How To Retrieve Field Values using odbc_result()?

After calling odbc_fetch_row(), the field values of the fetched row are available in the result set object. You can use odbc_result() to retrieve the value of any given field with two syntax formats:

$value = odbc_result($field_name);
#- Retrieving value by field name

$value = odbc_result($field_index);
#- Retrieving value by field index.
#- The index of the first field is 1.

The tutorial PHP script below shows you how to list tables in the database with multiple field values:

<?php
  $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter');

  $sql = "SELECT * FROM  sys.objects"
     . " WHERE type_desc='USER_TABLE'";
  $res = odbc_exec($con, $sql);
  print("User Tables:\n");
  while (odbc_fetch_row($res)) {
     print("   ".odbc_result($res,1));
     print(", ".odbc_result($res,'object_id'));
     print(", ".odbc_result($res,7)."\n");
  }
  odbc_free_result($res);

  odbc_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

⇒ odbc_tables() - Listing All Tables in the Database

⇐ odbc_fetch_row() - Looping through Result Set Objects

⇑ SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution

⇑⇑ SQL Server Connection Tutorials