= NOW()"; $rstTotal = mysql_query($strQuery) or die('Query ' . $strQuery . ' fallita: ' . mysql_error()); $recTotal = mysql_fetch_array($rstTotal, MYSQL_ASSOC); mysql_free_result($rstTotal); $intCount = (int) $recTotal['total']; } // Do the query $strQuery = "SELECT * FROM eventi WHERE data_fine >= NOW() ORDER BY data_inizio LIMIT " . $intPosition . ", " . $intPaging; $rstEventi = mysql_query($strQuery) or die('Query ' . $strQuery . ' fallita: ' . mysql_error()); ?>
';
if (! isset($_REQUEST['id']))
$_REQUEST['id'] = $recEventi['id'];
}
else
echo ' '; if ($recEventi['id'] == $_REQUEST['id']) echo ' ';
else
echo ' ';
echo ' ';
}
if ($i == 0)
echo 'Nessun evento in programma';
elseif ($intCount > $intPaging) {
// Pagination
echo '';
if (($recEventi['id'] == $_REQUEST['id']) && (strlen($recEventi['img']) > 0))
echo '';
echo $recEventi['titolo'] . ' Maggiori informazioni >> ' . $recEventi['testo_link'] . ' '; } else echo truncate($recEventi['testo'], 100) . 'Visualizza evento >>'; echo ' ';
if ($intPosition > 0)
echo '< Precedente ';
for ($i = 0, $j = 1; $i < $intCount; $i += $intPaging, $j++) {
if ($intPosition != $i)
echo '' . $j .' ';
else
echo $j . ' ';
}
if ($intPosition + $intPaging < $intCount) {
echo 'Successiva >';
}
echo ' ';
}
?>
|
||