query($query);
if ($conn->next_record())
print urldecode($conn->field_value("LOC_NAME")); ?>
|
query($query);
if ($conn->next_record())
$themeID = $conn->field_value("THEM_ID");
//---- get leisure services
$query = "SELECT distinct SERV_DESC_ID, DESC_NAME FROM services, descriptions
WHERE SERV_THEM_ID='".$themeID."'
AND SERV_DESC_ID=DESC_ID
AND SERV_LOC_ID='".$LOCID."'
ORDER BY SERV_DESC_ID";
$conn->query($query);
$i = 0;
$previousDescName = "";
while($conn->next_record())
{
if ($i == 0)
{ ?>
Activities |
|
field_value("DESC_NAME"))
{ ?>
|
field_value("DESC_NAME")?> |
field_value("DESC_NAME");
$SERVDESCID = $conn->field_value("SERV_DESC_ID");
$query2 = "SELECT distinct SERV_ID, SERVLANG_NAME as mainName
FROM services
LEFT JOIN services_languages ON (SERVLANG_LANG_ID='1' AND SERVLANG_SERV_ID=SERV_ID)
JOIN servicesdocuments ON SERVDOC_SERV_ID=SERV_ID
LEFT JOIN servicesdocuments_languages ON (SERVDOCLANG_LANG_ID='1' AND SERVDOCLANG_SERV_ID=SERVDOC_SERV_ID AND SERVDOCLANG_DOC_ID=SERVDOC_DOC_ID)
JOIN documents ON SERVDOC_DOC_ID=DOC_ID
WHERE SERV_THEM_ID='".$themeID."'
AND SERV_LOC_ID='".$LOCID."'
AND SERV_DESC_ID='".$SERVDESCID."'";
$conn2->query($query2);
while($conn2->next_record())
{ ?>
|
field_value("mainName")))?> |
|
field_value("SERV_ID")."' ORDER BY SP_ORDERNB";
$conn3->query($query3);
$rows = 0;
while($conn3->next_record())
{
print " ".utf8_decode($conn3->field_value("SP_TEXT"))."
";
$rows++;
}
if ($rows == 0)
print " Empty";
?> |
query($query);
if ($conn->next_record())
$themeID = $conn->field_value("THEM_ID");
//---- get lodging services
$query = "SELECT distinct SERV_DESC_ID, DESC_NAME FROM services, descriptions
WHERE SERV_THEM_ID='".$themeID."'
AND SERV_DESC_ID=DESC_ID
AND SERV_LOC_ID='".$LOCID."'
ORDER BY SERV_DESC_ID";
$conn->query($query);
$i = 0;
$previousDescName = "";
while($conn->next_record())
{
if ($i == 0)
{ ?>
Lodging |
|
field_value("DESC_NAME"))
{ ?>
|
field_value("DESC_NAME")?> |
field_value("DESC_NAME");
$SERVDESCID = $conn->field_value("SERV_DESC_ID");
$query2 = "SELECT distinct SERV_ID, SERVLANG_NAME as mainName
FROM services
LEFT JOIN services_languages ON (SERVLANG_LANG_ID='1' AND SERVLANG_SERV_ID=SERV_ID)
JOIN servicesdocuments ON SERVDOC_SERV_ID=SERV_ID
LEFT JOIN servicesdocuments_languages ON (SERVDOCLANG_LANG_ID='1' AND SERVDOCLANG_SERV_ID=SERVDOC_SERV_ID AND SERVDOCLANG_DOC_ID=SERVDOC_DOC_ID)
JOIN documents ON SERVDOC_DOC_ID=DOC_ID
WHERE SERV_THEM_ID='".$themeID."'
AND SERV_LOC_ID='".$LOCID."'
AND SERV_DESC_ID='".$SERVDESCID."'";
$conn2->query($query2);
while($conn2->next_record())
{ ?>
|
field_value("mainName")))?> |
|
field_value("SERV_ID")."' ORDER BY SP_ORDERNB";
$conn3->query($query3);
$rows = 0;
while($conn3->next_record())
{
print " ".utf8_decode($conn3->field_value("SP_TEXT"))."
";
$rows++;
}
if ($rows == 0)
print " Empty";
?> |
query($query);
if ($conn->next_record())
$themeID = $conn->field_value("THEM_ID");
//---- get transport services
$query = "SELECT distinct SERV_DESC_ID, DESC_NAME FROM services, descriptions
WHERE SERV_THEM_ID='".$themeID."'
AND SERV_DESC_ID=DESC_ID
AND SERV_LOC_ID='".$LOCID."'
ORDER BY SERV_DESC_ID";
$conn->query($query);
$i = 0;
$previousDescName = "";
while($conn->next_record())
{
if ($i == 0)
{ ?>
Transport |
|
field_value("DESC_NAME"))
{ ?>
|
field_value("DESC_NAME")?> |
field_value("DESC_NAME");
$SERVDESCID = $conn->field_value("SERV_DESC_ID");
$query2 = "SELECT distinct SERV_ID, SERVLANG_NAME as mainName
FROM services
LEFT JOIN services_languages ON (SERVLANG_LANG_ID='1' AND SERVLANG_SERV_ID=SERV_ID)
JOIN servicesdocuments ON SERVDOC_SERV_ID=SERV_ID
LEFT JOIN servicesdocuments_languages ON (SERVDOCLANG_LANG_ID='1' AND SERVDOCLANG_SERV_ID=SERVDOC_SERV_ID AND SERVDOCLANG_DOC_ID=SERVDOC_DOC_ID)
JOIN documents ON SERVDOC_DOC_ID=DOC_ID
WHERE SERV_THEM_ID='".$themeID."'
AND SERV_LOC_ID='".$LOCID."'
AND SERV_DESC_ID='".$SERVDESCID."'";
$conn2->query($query2);
while($conn2->next_record())
{ ?>
|
field_value("mainName")))?> |
|
field_value("SERV_ID")."' ORDER BY SP_ORDERNB";
$conn3->query($query3);
$rows = 0;
while($conn3->next_record())
{
print " ".utf8_decode($conn3->field_value("SP_TEXT"))."
";
$rows++;
}
if ($rows == 0)
print " Empty";
?> |
query($query);
if ($conn->next_record())
$themeID = $conn->field_value("THEM_ID");
//---- get wellness services
$query = "SELECT distinct SERV_DESC_ID, DESC_NAME FROM services, descriptions
WHERE SERV_THEM_ID='".$themeID."'
AND SERV_DESC_ID=DESC_ID
AND SERV_LOC_ID='".$LOCID."'
ORDER BY SERV_DESC_ID";
$conn->query($query);
$i = 0;
$previousDescName = "";
while($conn->next_record())
{
if ($i == 0)
{ ?>
Wellness |
|
field_value("DESC_NAME"))
{ ?>
|
field_value("DESC_NAME")?> |
field_value("DESC_NAME");
$SERVDESCID = $conn->field_value("SERV_DESC_ID");
$query2 = "SELECT distinct SERV_ID, SERVLANG_NAME as mainName
FROM services
LEFT JOIN services_languages ON (SERVLANG_LANG_ID='1' AND SERVLANG_SERV_ID=SERV_ID)
JOIN servicesdocuments ON SERVDOC_SERV_ID=SERV_ID
LEFT JOIN servicesdocuments_languages ON (SERVDOCLANG_LANG_ID='1' AND SERVDOCLANG_SERV_ID=SERVDOC_SERV_ID AND SERVDOCLANG_DOC_ID=SERVDOC_DOC_ID)
JOIN documents ON SERVDOC_DOC_ID=DOC_ID
WHERE SERV_THEM_ID='".$themeID."'
AND SERV_LOC_ID='".$LOCID."'
AND SERV_DESC_ID='".$SERVDESCID."'";
$conn2->query($query2);
while($conn2->next_record())
{ ?>
|
field_value("mainName")))?> |
|
field_value("SERV_ID")."' ORDER BY SP_ORDERNB";
$conn3->query($query3);
$rows = 0;
while($conn3->next_record())
{
print " ".utf8_decode($conn3->field_value("SP_TEXT"))."
";
$rows++;
}
if ($rows == 0)
print " Empty";
?> |