include "connessioni.inc";
?>
guida
Home
Registrati
Perso i codici?
Cerca un lotto
$pagina="q";?>
if (!isset($query)) {?>
}
$sql="select now() as data from lookup";
$res = mysql_db_query($db,$sql,$dbcon);
$row = mysql_fetch_array ($res);
if ($row){
$pagina = $row['testo'];
$oraserver = $row['data'];
}
?>
Sezioni:
$sql="select chiave,testo from lookup where chiave in ('Nu','Fi') and tabella='SE' order by testo desc";
$res = mysql_db_query($db,$sql,$dbcon);
while ($row = mysql_fetch_array ($res))
{
$sql="select count(*) as num from lotti where sezione='".$row['chiave']."' and dtfineasta >=curdate()";
$reslotti = mysql_db_query($db,$sql,$dbcon);
$rowlotti = mysql_fetch_array ($reslotti);
?>=$row[testo]."(".$rowlotti['num'].")"?>
}
?>
$sql="select chiave,testo from lookup where chiave not in ('Nu','Fi') and tabella='SE' order by testo asc";
$res = mysql_db_query($db,$sql,$dbcon);
while ($row = mysql_fetch_array ($res))
{
$sql="select count(*) as num from lotti where sezione='".$row['chiave']."' and dtfineasta >=curdate()";
$reslotti = mysql_db_query($db,$sql,$dbcon);
$rowlotti = mysql_fetch_array ($reslotti);
if ($rowlotti['num'] > 0) {
?>=$row[testo]."(".$rowlotti['num'].")"?>
}
}
?>
Metti in vendita
Aggiorna la foto di un lotto
Riproponi un lotto scaduto
News
Listini
NLM
