could you help me guys to translate this code from PHP MySQL to PHP ODBC.
i'm having a hard time to run this page using the PHP ODBC which uses MSSQL connection.
any help would be very much appreciated..
thanks in advance ^^
<?php
$return_arr = array();
$sql = mysql_query("SELECT DISTINCT(empLName) FROM employee_info WHERE empLName LIKE '%" . $_GET['term'] . "%'");
$resultSQL = mysql_num_rows($sql);
if ($resultSQL != '0')
{
while ($row = mysql_fetch_array($sql))
{
$row_array['value'] = $row['empLName'];
array_push($return_arr,$row_array);
}
}
mysql_close();
echo json_encode($return_arr);
?>