Ciao, la query che sto per postare mi produce un'errore, io vorrei restringere i risultati inserendo dei periodi, "DAL ----- AL -----" per intenderci, e pertanto ho modificato la query in questo modo:
DATA_INS >= '$DATA_INS_0%'
DATA_INS < '$DATA_INS_1%'
cioè per mostrare solo i risultati compresi dalla data del "$DATA_INS_0%" alla data del "$DATA_INS_1%".
Ciao, grazie, AIUTO AIUTO!!
----------------------------PHP
<?php
include ("../../Elementi/Connessione.php");
include ("../../Elementi/Navigazione_Print.php");
$search_nr_0 = $_GET['search_nr_0'];
$search_nr_1 = $_GET['search_nr_1'];
$search_cognome = $_GET['search_cognome'];
$search_nome = $_GET['search_nome'];
$DATA_INS_0 = $_GET['DATA_INS_0'];
$DATA_INS_1 = $_GET['DATA_INS_1'];
$COMM_1 = $_GET['COMM_1'];
$COMM_2 = $_GET['COMM_2'];
$COMM_3 = $_GET['COMM_3'];
$COMM_4 = $_GET['COMM_4'];
$COMM_5 = $_GET['COMM_5'];
$COMM_6 = $_GET['COMM_6'];
$COMM_7 = $_GET['COMM_7'];
$COMM_8 = $_GET['COMM_8'];
$COMM_9 = $_GET['COMM_9'];
$COMM_10 = $_GET['COMM_10'];
$COMM_11 = $_GET['COMM_11'];
$COMM_12 = $_GET['COMM_12'];
$res = paging("SELECT * FROM $tabella2
WHERE ID LIKE '$ID%'
AND NR >= '$search_nr_0%'
AND NR < '$search_nr_1%'
AND COGNOME LIKE '$search_cognome%'
AND NOME LIKE '$search_nome%'
AND DATA_INS >= '$DATA_INS_0%'
AND DATA_INS < '$DATA_INS_1%'
AND COMM_1 LIKE '$COMM_1%'
AND COMM_2 LIKE '$COMM_2%'
AND COMM_3 LIKE '$COMM_3%'
AND COMM_4 LIKE '$COMM_4%'
AND COMM_5 LIKE '$COMM_5%'
AND COMM_6 LIKE '$COMM_6%'
AND COMM_7 LIKE '$COMM_7%'
AND COMM_8 LIKE '$COMM_8%'
AND COMM_9 LIKE '$COMM_9%'
AND COMM_10 LIKE '$COMM_10%'
AND COMM_11 LIKE '$COMM_11%'
AND COMM_12 LIKE '$COMM_12%'
ORDER BY ID DESC");
if (!$res[0]) {echo "Errore Interno 001";}
else
{
while($dati = mysql_fetch_array($res[0]))
{
echo "<div id=Etichetta>";
echo "
".$dati['TIT']; echo " " .$dati['COGNOME'];echo " " .$dati['NOME'];
echo "
".$dati['VIA_R']; echo ", " .$dati['CIV_R'];
echo "
".$dati['CAP_R']; echo " - ".$dati['CITTA_R'];echo " (".$dati['PROV_R'];echo")</td>";
echo "</div>";
}
}
echo "
<center><div id=pag>" .$res[1]; "</div></center>";
?>
Rispondi quotando
