CC Menu disappears on load db results

Gabri 27 Mar, 2012
Dear Dr. Greyhead, hope you can help on this problem: thanks to your precious tutorials i was able to create a cc page linked to a db table which displays a dropdown list of one field (building names). After selecting from the list, a submit button displays the whole record related to that field just underneath in the same page. Everything works great except the navigation menu and the page banners disappear thus leaving the page with no navigation. The menu is not linked to all the items; if i link the menu to all the items the problem is gone, but i cannot have that menu in all the views. I use Joomla! 1.5.23 (italian), CC V2 RC3, CF V3.2.0, CF Plugin V3.1 RC5. Here's my code:
WHERE SQL:
<?php
$Denominazione = JRequest::getInt('Denominazione', '99999', 'post');
if ( $Denominazione) {
    echo " WHERE `ID` = '$Denominazione' ";
}
?>

HEADER
    <div class="form_item">
      <div> </div>
    </div>

    <div class="form_item">
      <div>
        <label style="width: 150px;">Seleziona un edificio dalla lista: </label>
        <select id="Denominazione" size="1" title="seleziona"  name="Denominazione">
        <option value="1">...</option>
         
    <?php
    $Denominazione = JRequest::getInt('Denominazione', 0, 'post');
    $db =& JFactory::getDBO();
    $query = "
        SELECT `ID`, `Denominazione`
            FROM `jos_spmn_territorio` ORDER BY `Denominazione` ;
    ";
    $db->setQuery($query);
    $data = $db->loadObjectList();
    foreach ( $data as $d ) {
      $select = '';
      if ( $d->ID == $Denominazione ) {
        $select = "selected='selected'";
      }   
      echo '<option value="'.$d->ID.'" '.$select.' >'.$d->Denominazione.'</option>';
    }
    ?>
        </select>   
       
        <input value="visualizza scheda" name="button" type="submit" />
      </div>
      <div> </div>
    </div>

BODY
<p><table border="0" cellpadding="0" cellspacing="0" width="750" id="table10" style="border-collapse: collapse" bordercolor="#111111">
	<tr>
		<td align="left" width="717" valign="top" colspan="3">
        <font face="Trebuchet MS" color="#000080">{Denominazione}</font></td>
	</tr>
	<tr>
		<td align="left" width="717" valign="top" colspan="3">
         </td>
	</tr>
	<tr>
		<td align="center" width="300" valign="top">
        <table border="0" cellpadding="0" cellspacing="0" id="table13">
			<tr>
				<td align="center" valign="top">
        <table border="0" cellspacing="0" bordercolor="#111111" id="table14" cellpadding="0">
          <tr>
            <td width="100%" align="center"><img border="0" src="{Immagine01}"></td>
          </tr>
        </table>
        		</td>
			</tr>
			</table>
        </td>
		<td align="left" valign="top" width="20">
		<p> </td>
		<td align="left" valign="top" width="397">
		<table border="0" cellpadding="0" cellspacing="0" width="100%" id="table12">
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">Tipologia:</font><font face="Verdana" size="2" color="#000080"> {Tipologia} 
				</font></td>
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">Compl. 
				appartenenza:</font><font face="Verdana" size="1" color="#000080"> </font><font face="Verdana" size="2" color="#000080">{Compl_Appartenenza}</font></td>
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">
				Altra denominazione:</font><font face="Verdana" size="2" color="#000080"> {Altra_Denominazione}</font></td>
			</tr>
			<tr>
				<td height="15" colspan="2">
                <font size="1" color="#F1F1F1">
				{ID}
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">Indirizzo:</font><font face="Verdana" size="1" color="#000080"> </font><font face="Verdana" size="2" color="#000080">{Indirizzo}</font></td>
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">Quartiere:</font><font face="Verdana" size="2"> <font color="#000080">{Quartiere}</font></font></td>
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">
				Utilizzo:</font><font face="Verdana" size="1" color="#000080"> </font><font face="Verdana" size="2" color="#000080">{Utilizzo}</font></td>
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">Resp. proTempore:</font><font face="Verdana" size="1" color="#000080"> </font><font face="Verdana" size="2" color="#000080">{Resp_proTempore}</font></td>
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">
				Telefono: </font><font face="Verdana" size="2" color="#000080">{Telefono}</font></td>
			</tr>
			<tr>
				<td colspan="2">
                 </td>
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">Stato:</font><font face="Verdana" size="1" color="#000080"> </font><font face="Verdana" size="2" color="#000080">{Stato}</font></td>
			</tr>
			<tr>
				<td colspan="2"><font face="Verdana" size="1" color="#808080">Orari:</font><font face="Verdana" size="1" color="#000080"> </font><font face="Verdana" size="2" color="#000080">{Orari}</font></td>
			</tr>
			<tr>
				<td height="10" colspan="2">
                 </td>
			</tr>
			<tr>
				<td width="24%"><font face="Verdana" size="1" color="#808080">Curatore SPMN: </font>
				</td>
				<td width="76%">
				<font face="Verdana" size="2" color="#000080">
				{Curatore}</font></td>
			</tr>
			<tr>
				<td width="24%">
                 </td>
				<td width="76%"><font face="Verdana" size="2" color="#000080">
				{Cur_Tel}</font></td>
			</tr>
			<tr>
				<td width="24%">
                 </td>
				<td width="76%"><font face="Verdana" size="2" color="#000080">
				{Cur_Email}</font></td>
			</tr>
			<tr>
				<td colspan="2">
                 </td>
			</tr>
			<tr>
				<td colspan="2">
                <font face="Verdana" size="1" color="#808080">Cenni storici:</font><font face="Verdana" size="1" color="#000080"> </font></td>
			</tr>
			<tr>
				<td colspan="2">
                <font face="Verdana" size="1">
				{Cenni_Storici}
				</font></td>
			</tr>
			</table>
		</td>
	</tr>
	<tr>
		<td align="left" colspan="3" height="8">
                </td>
	</tr>
	</table>
</p>

Thanks! I'm sending a big smile from Italy along with a beer!
This topic is locked and no more replies can be posted.