</TABLE>
<?php
//-----------------------------------------------------------------------------------
if (cShowRelatedQueries) {
for ($i = 0; $i < 10; $i++) {
traceHide("cShowRelatedQueries=true");
$relatedItem = getName($i);
traceHide("relatedItem=" . $relatedItem);
if ($relatedItem != "") {
$relatedTitle = "Other Queries using " . $relatedItem;
//Look for related enquiries, that is, where this user's query string variables
// can be used in other adHocQuery records
$relatedSelect = "SELECT m.menu_num, m.line_num, m.title, q.select_stmt" . " FROM queries q JOIN menus m ON m.main_query_num = q.query_num" . " WHERE q.select_stmt LIKE '%" . cParamDelimiter . $relatedItem . cParamDelimiter . "%'" . " AND m.hidden = 0" . " AND q.query_num <> " . $thisQuery . " AND (q.pre_select IS NULL OR q.pre_select = '')" . " AND EXISTS( SELECT * FROM menus mm WHERE mm.main_query_num = q.query_num GROUP BY mm.main_query_num" . " HAVING m.menu_num = MIN(mm.menu_num))" . " ORDER BY m.title";
traceHide("relatedSelect=" . $relatedSelect);
$adhocStmt = pdoQuery($relatedSelect, $connAdHoc);
$numRecords = pdoRowCount($adhocStmt);
traceHide($relatedSelect);
traceHide($numRecords . " records");
if ($numRecords > 0) {
?>
<br/>
<p class="ahTitleOtherLinks"><?php
echo $relatedTitle;
?>
(<?php
echo $numRecords;
?>
items)</p>
<UL>
<?php
}
<TITLE>Ad Hoc Menu</TITLE>
<LINK REL="stylesheet" HREF=<?php
echo cStylesheet;
?>
TYPE="text/css" />
</HEAD>
<BODY BGCOLOR="#000000">
<!-- Header table -->
<TABLE BORDER="0" WIDTH="800" CELLPADDING="0" CELLSPACING="0">
<TR><TD WIDTH="3"> </TD><TD WIDTH="597">
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%"><TR>
<TD><P CLASS="title">Ad Hoc Menu (<?php
echo $nextMenu;
?>
/ <?php
echo pdoRowCount($adHocStmt);
?>
)</P></TD>
<?php
if (cMultipleSites) {
$sqlSites = "SELECT site_num, site_name FROM sites";
$adHocSitesStmt = pdoQuery($sqlSites, $connAdHoc);
$adHocSitesRows = pdoFetch($adHocSitesStmt);
?>
<TD>
<FORM ACTION="adHocMenu.php" METHOD="post">
<SELECT NAME="sitenum" SIZE="1" ONCHANGE="this.form.submit();">
<?php
foreach ($adHocSitesRows as $row) {
if ($siteNum == pdoData($row, "site_num")) {
$sel = "SELECTED";
?>
<A HREF="adHocAdmin.php?menu_num=<?php
echo $row['menu_num'];
?>
&line_num=<?php
echo $row['line_num'];
?>
&up=1">Up</A>
<?php
}
?>
</td>
<td></td>
<td class="ahMenu1">
<?php
if ($i < pdoRowCount($adHocStmt)) {
?>
<A HREF="adHocAdmin.php?menu_num=<?php
echo $row['menu_num'];
?>
&line_num=<?php
echo $row['line_num'];
?>
&down=1">Down</A>
<?php
}
?>
</td>
<td></td>
<td class="ahMenu1">
<?php
