<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOC_ID = id of the location
	// THEME = the theme
	// LANG (optional)
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	if (empty($LANG))
		$query = "SELECT distinct SERV_ID, SERV_NAME as SNAME FROM services, thematics WHERE SERV_LOC_ID='".$LOC_ID."' AND SERV_THEM_ID=THEM_ID AND THEM_NAME='".$THEME."' ORDER BY SERV_NAME";
	else
	{	$query = "SELECT distinct SERV_ID, SERVLANG_NAME as SNAME FROM services, thematics, services_languages, languages
			WHERE SERV_LOC_ID='".$LOC_ID."'
			  
			  AND SERVLANG_SERV_ID=SERV_ID
			  AND SERVLANG_LANG_ID=LANG_ID
			  AND LANG_CODE='".$LANG."'
			  
			  AND SERV_THEM_ID=THEM_ID
			  AND THEM_NAME='".$THEME."'
			  ORDER BY SERV_NAME";
	}
	$conn->query($query);

	$idTab = "";
	$titleTab = "";
	$nextVal = "";
	while($conn->next_record())
	{
		$idTab.= $nextVal.$conn->field_value("SERV_ID");
		$titleTab.= $nextVal.utf8_encode($conn->field_value("SNAME"));
		$nextVal = "|";
	}

	if ($nextVal != "")
	{
		//---- display data
		print "idTab=".$idTab;
		print "&titleTab=".$titleTab;
	}
	else
		print "RESUTL=error0";
?>