<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOC_ID = id of the location
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- get all elements of the guide
	$query = "SELECT * FROM documents WHERE DOC_LOC_ID='".$LOC_ID."' AND (DOC_TYPE='IMG' OR DOC_TYPE='PAN') ORDER BY DOC_NAME";
	$conn->query($query);

	$idTab = "";
	$filenameTab = "";
	$titleTab = "";
	$keywordTab = "";
	$nextVal = "";
	while($conn->next_record())
	{
		$idTab.= $nextVal.$conn->field_value("DOC_ID");
		$filenameTab.= $nextVal.utf8_encode($conn->field_value("DOC_FILE"));
		$titleTab.= $nextVal.utf8_encode($conn->field_value("DOC_NAME"));
		$keywordTab.= $nextVal.utf8_encode($conn->field_value("DOC_KEYWORD"));
		$nextVal = "|";
	}


	//---- display data
	print "idTab=".$idTab;
	print "&filenameTab=".$filenameTab;
	print "&titleTab=".$titleTab;
	print "&keywordTab=".$keywordTab;
?>