<?php

require('includes/application_top.php');

$return_arr = array();

 $fetch = tep_db_query("select * from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS . " p on pd.products_id = p.products_id WHERE p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and pd.products_name LIKE '%" . $_GET['term'] . "%' ");


 
while ($row = tep_db_fetch_array($fetch)) { 

                array_push($return_arr,array('label' =>$row['products_model'] .'-'. $row['products_name'] ,'value' => $row['products_model'] ,'name'=>$row['products_name'] ,'price' => $row['products_price'] ));  

}  


print json_encode($return_arr); 


?>