Ok inserisco qui sotto il codice:
codice:
<?php session_start(); include("gestione/codicicharter.php"); include("gestione/tablescharter.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <TITLE>Barche <script language='javascript' src='gestione/scriptcomuni.js'></script> <link href="stile/stylecharter.css" rel="stylesheet" type="text/css" /> <style type="text/css"> body { margin-left: 0px; margin-right: 0px; } </style> </head> <body> <div class='contentdiv'>
<a name='barcheinasta'></a> </p> <div class="colsx"></div> <FORM ACTION="lista2.php" METHOD="post"> <TABLE border="0" width="1000" height="auto"> <tr> <td colspan="2"><div align="left">Scegli fra Nuovo, Usato o Charter</div></td> </tr> <tr> <td><div align="left"> <SELECT NAME="where" size="3" > <OPTION VALUE="nuova">Nuovo </option> <OPTION VALUE="usata">Usato</option> <OPTION VALUE="charter">Charter</option> </SELECT> <input type="image" id="where" value="Stato" name="colonna" src="stile/img/cerca.jpg" align="center" alt="cerca" title="cerca" /> </div> <td align="center"><div align="left"></div></td> <div align="left"> </td> </div> <td> <p align="left"></p> <p align="left"></p> </td> </tr> </FORM></p>
</p>
</p> <div class='fullcols'>
</p> <?php $q = "select count(*) as numb from barche"; $res2 = mysql_query($q, conndb()); $numb = mysql_fetch_object($res2); $numb = $numb->numb; echo"Barche disponibili: $numb"; ?> </div> <a name='listabarche'></a></div> <div class='colsx'> <div class="colsx" id="tipobarca">Cliccare sulla colonna per sortare le barche</div>
</p>
<?php $risvis = 10; $where = ""; $pagina =1; $orderby = ""; $verso = ""; if((isset($_REQUEST['eliminafiltro'])) && (isset($_SESSION['where']))) unset($_SESSION['where']); if(isset($_REQUEST['pagina'])) {$_SESSION['pagina'] = $_REQUEST['pagina']; } if(isset($_REQUEST['risvis'])) {$_SESSION['risvis'] = $_REQUEST['risvis']; $_SESSION['pagina'] = 1;} if(isset($_REQUEST['orderby'])){ if(!isset($_SESSION['orderby']) || (isset($_SESSION['orderby']) && ($_SESSION['orderby']) != $_REQUEST['orderby'])){$_SESSION['verso'] = "asc";} if(isset($_SESSION['orderby']) && ($_SESSION['orderby'] == $_REQUEST['orderby'])){if($_SESSION['verso'] == "asc") $_SESSION['verso']="desc"; else $_SESSION['verso']="asc";} $_SESSION['orderby'] = $_REQUEST['orderby']; } if(isset($_REQUEST['where']) && isset($_REQUEST['colonna'])) { $w = $_REQUEST['where']; if($_REQUEST['tipo'] == 'date'){ if(ereg("[0-9]{0,2}-[0-9]{0,2}-[0-9]{0,4}", $w)){ list($giorno, $mese, $anno) = explode("-", $w); if($anno == "")$anno = "____"; if($mese == "")$mese = "__"; if($giorno == "")$giorno = "__"; $w = "$anno-$mese-$giorno"; } } $_SESSION['where'] = $_REQUEST['colonna']." like "; $_SESSION['where'] .= " '%$w%' "; } if(isset($_SESSION['pagina'])) $pagina = $_SESSION['pagina']; if(isset($_SESSION['risvis'])) {$risvis = $_SESSION['risvis']; if($risvis<10)$risvis = 10; } if(isset($_SESSION['where'])) $where = $_SESSION['where']; if(isset($_SESSION['orderby'])) $orderby = $_SESSION['orderby']; if(isset($_SESSION['verso'])) $verso = $_SESSION['verso']; $intestazioni = array( "Id", "Foto", "Cantiere", "Modello", "Tipologia", "Anno", "Lunghezza_mt", "Prezzo", "Stato" ); echo lb3($intestazioni, "inventario", $where, $orderby, $verso, $pagina, $risvis); ?> </p>
</p> </div> </div> </body> </html>
Comunque prova anche il link:
http://www.barcheinasta.com/testbarche2/lista2.php
Se hai due minuti prova a selezionare dalla select con windows così vedi cosa fa, grazie ancora.
A presto,