include("admin/user_property_2.php");
$conn=mysql_connect($db_host,$db_user,$db_password) or die ("Impossibile connetersi al database");
mysql_select_db($db_name,$conn) or die ("impossibile selezionare il database");
//la query chede al db di selezionare tutti ("*") i campi e di ordinarli in ordine "id" decrescente
$query = "SET NAMES 'utf8'";
mysql_query($query, $conn);
$sql = "Select * from aziende where scheda!='' order by regione, nome";
$r=mysql_query($sql,$conn) or die(mysql_error());
$last_reg="";
$rn=0;
while ($row = mysql_fetch_array($r)) {
if ($row['regione']!=$last_reg and $last_reg!="") {
?>
if ($rn==7 or $rn==14) {
?>
}
if ($rn==18) {
?>
}
}
if ($row['regione']!=$last_reg) {
?>
}
?>
-
if ($row['regione']!=$last_reg) {
$last_reg=$row['regione'];
$rn++;
}
}
?>
PERLAGE ITALIA METODO CLASSICO
$query = "SET NAMES 'utf8'";
mysql_query($query, $conn);
$sql = "Select * from aziende where spumanti!='' order by nome";
$r=mysql_query($sql,$conn) or die(mysql_error());
$last_reg="";
$rn=0;
while ($row = mysql_fetch_array($r)) {
?>
-
}
?>