Use ODBC to connect to the database in NT IIS

$ Connection = int odbc_connect (string DSN, string user, string password) to establish a database connection,

$ QUERY_STRING = "query record conditions"
For example: $ QUERY_STRING = "select * from table"

Use $ cur = int odbc_exec (INT connection_id, string QUERY_STRING) to retrieve the database and put the record set into the $ cur variable.

Use while (odbc_fetch_row ($ cur )){
$ Var1 = odbc_result ($ cur, 1 );
$ Var2 = odbc_result ($ cur, 1 );
...
}
Read $ cur from the dataset returned by odbc_exec.

Finally, odbc_close (INT connection_id) closes the database connection.

The odbc_result () function is used to obtain the specified field value of the current record.