[EDIT] FILE: odbctest.php

<? // connect to a DSN "mydb" with a user and password "marin" $connect = odbc_connect("JDBC", "guest", "sybase"); // query the users table for name and surname $query = "SELECT * from sysusers"; // perform the query $result = odbc_exec($connect, $query); // fetch the data from the database while(odbc_fetch_row($result)){ $suid = odbc_result($result, 1); $uid = odbc_result($result, 2); $gid = odbc_result($result, 3); $name = odbc_result($result, 4); print("$name|$suid|$uid|$gid\n"); } // close the connection odbc_close($connect); ?>
SAVE CANCEL