English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية

Basic PHP Tutorial

Advanced PHP Tutorial

PHP & MySQL

PHP Reference Manual

Usage and Example of PHP odbc_special_columns() Function

PHP ODBC Reference Manual

The odbc_special_columns() function is used to retrieve special columns

Syntax

resource odbc_specialcolumns ( resource $connection_id , int $type , string $qualifier , string $owner , string $table , int $scope , int $nullable )

Definition and Usage

Retrieves the optimal column set that uniquely identifies a row in a table, or retrieves any values automatically updated in the row when the transaction updates it.

Return Value

Returns an odbc result identifier on success, otherwise returns false

Parameter

NumberParameters and Description
1

connection_id

It contains information about the connection identifier

2

qualifier

It contains information about the qualifier

3

owner

It contains information about the owner

4

nullable

It contains information about nullable options

Example

Try the following example

<?php
   $input_ID = odbc_connect("DSN", "user_id", "pass_id");
   $result = odbc_specialcolumns($input_ID, 0, "Northwind", "dbo", "Employees", 0, 0);
   
   odbc_result_all($result);
 ?>

PHP ODBC Reference Manual