<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// PROVID = id of the provider
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);


	$IDTab = "";
	$titleTab = "";

	//---- get providers
	$query = "SELECT * FROM companies WHERE COMP_ID='".$PROVID."'";
	$conn->query($query);

	if($conn->next_record())
	{
		//---- display data
		print "legalName=".utf8_encode($conn->field_value("COMP_NAME"));
		print "&legalAddress=".utf8_encode($conn->field_value("COMP_ADDRESS"));
		print "&officeNum=".utf8_encode($conn->field_value("COMP_PHONE"));
		print "&mobilNum=".utf8_encode($conn->field_value("COMP_MOBILE"));
		print "&faxNum=".utf8_encode($conn->field_value("COMP_FAX"));
		print "&email=".utf8_encode($conn->field_value("COMP_EMAIL"));
		print "&website=".utf8_encode($conn->field_value("COMP_URL"));
		print "&googleStreetNum=".utf8_encode($conn->field_value("COMP_GSTREETNUM"));
		print "&googleStreet=".utf8_encode($conn->field_value("COMP_GSTREET"));
		print "&googleCity=".utf8_encode($conn->field_value("COMP_GCITY"));
		print "&googleCode=".utf8_encode($conn->field_value("COMP_GCODE"));
		print "&googleCountry=".utf8_encode($conn->field_value("COMP_GCOUNTRY"));
	}
	else
		print "RESULT=error0";
?>