<?php
$MYOB_dbfile = 'C:\Premier10.hk_English\Clearwtr.MYO';
$MYOB_user = 'Administrator';
$MYOB_pass = '';
$MYOB_key_file = '';
$MYOB_app_path = 'C:\Premier10.hk_English\Myobp.exe';

$MYOB_conn_str = "Driver={MYOB_ODBC};" . "Database=" . $MYOB_dbfile . ";" . "TYPE=MYOB;UID=" . $MYOB_user . ";PWD=" . $MYOB_pass . ";" . "KEY=" . $MYOB_key_file . ";ACCESS_TYPE=READ_WRITE;" . "HOST_EXE_PATH=" . $MYOB_app_path . ";" . "DRIVER_COMPLETION=DRIVER_PROMPT; SQL_LOGIN_TIMEOUT=30;" . "SUPPRESS_WARNINGS=false;";

$conn = odbc_connect($MYOB_conn_str, '', '');

$query = "select name, lastname from suppliers order by name desc, lastname desc";

$result = odbc_exec($conn, $query) or die ("cannot find table");
?>