xuexue 15 Junior Poster

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);

?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.