$db = JFactory::getDbo();
		$uri =JURI::getInstance();
		$url= $uri->root();
		
		
		
		$query='SELECT * FROM #__naderapp_country order by country_name' ;
		$db->setQuery($query); 
		$parents=$db->loadObjectList();


         $procedure=array();
		
	if($parents)
	{	
		
		for($i=0;$i<count($parents);$i++)
		{
			$row=$parents[$i];
			
			$procedurearray=array();
				
			$procedurearray['country_id']=$parents[$i]->country_id;
			$procedurearray['country_name']=$parents[$i]->country_name;
			$procedure[]=$procedurearray;
		}
		
		
		
		 $arr = array('success' => '1','procedure' => $procedure);
   		 echo json_encode($arr);exit;
		
	}
	else
	{
		
		  $arr = array('success' => '0','procedure' => 'No Record Found');
 		  echo json_encode($arr);exit;
		
	}