anche tutto..
codice:function cerca_nella_regione ($connessione,$campo,$provincia,$tipologia,$prezzo,$mq,$codice,$idregione){ $controlla = 0; // QUI!! $query_search = "SELECT * FROM `province` WHERE `idregione` ='$idregione'"; $es_query_search = mysql_query($query_search, $connessione) or die(mysql_error()); $totalRows_query_search = mysql_num_rows($es_query_search); if($totalRows_query_search > 0){ $stampa .='<script language="JavaScript" type="text/javascript">alert("'.titoli_spa($connessione, $campo, 149).'");</script>'; $stampa .='<table border="0" cellspacing="0" cellpadding="0" class="table_centrale"> <tr><td class="menu">[img]img/pallino.gif[/img] '.titoli_spa($connessione, $campo, 150).'</td></tr> <tr><td style="padding-top:4px; padding-bottom:4px"><table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#E6FC97"> <tr><td height="17" colspan="5"></td></tr> <tr><td width="17"></td>'; while($row_query_search = mysql_fetch_assoc($es_query_search)) { $provincia = $row_query_search['idprovincia']; $query_interno = "SELECT * FROM `immobili` WHERE `clausola` = 'vendita' AND `id_provincia` = '$provincia' AND `id_tipologia` = '$tipologia' AND `stato` =1"; $es_query_interno = mysql_query($query_interno, $connessione) or die(mysql_error()); $totalRows_query_interno = mysql_num_rows($es_query_interno); $controlla += $totalRows_query_interno;// QUI!! $x = 0; while($row_query_interno = mysql_fetch_assoc($es_query_interno)) { $id = $row_query_interno['id']; $mq_commerciali = $row_query_interno['mq_commerciali']; $prezzo = $row_query_interno['prezzo']; $riservata = $row_query_interno['riservata']; $id_provincia = $row_query_interno['id_provincia']; $comune = $row_query_interno['comune']; $prezzo = number_format($prezzo, 2, ',' , '.'); if($prezzo == '0,00'){ $st_prezzo = ""; }else if($riservata == 1){ $st_prezzo = ""; }else{ $st_prezzo = "€ $prezzo"; } $stampa .= '<td><table width="130" border="0" cellspacing="0" cellpadding="0" bgcolor="#E6FC97"> <tr> <td class="bgvetrina1" style="padding-bottom:6px;padding-left:1px">[img]/img/immibili/'.$id.'/105x75.jpg[/img]</td> </tr> <tr> <td>'.$comune.' '.cerca_province1($connessione,$id_provincia).' mq '.$mq_commerciali.' '.$st_prezzo.'</td> </tr> <tr> <td valign="bottom">» '.titoli_spa($connessione, $campo, 91).' » '.titoli_spa($connessione, $campo, 92).'</td> </tr> <tr> <td valign="bottom"></td> </tr> </table></TD>'; $x++; if($x == 5){ $stampa .= '</tr><tr><td height="17" colspan="5"></td></tr> <tr><td width="17"></td>'; $x = 0; } }//chiudo while }// chiudo while $stampa .= '<tr><td height="4" colspan="5">[img]img/spacer.gif[/img]</td></tr> </table> </td></tr> </table>'; }// chiudo if return $stampa; }
se faccio echo per capire cosa esce viene! 002020
grazie


Rispondi quotando