1){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_mail' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_mail="";
$PS="";
}
if($va_av=="SI"){
$sql="SELECT * FROM rin_clienti WHERE RagioneSociale > '$RagioneSociale' AND NOTE1 NOT LIKE '%MailF38%' AND AttivitaPrevalente NOT LIKE '%NON_INV%' AND Stato = 'italia' AND length(Email) > 4 ORDER BY RagioneSociale asc LIMIT 1";
$res=mysql_query($sql);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$va_av="";
$PS="";
}
if(strlen($id_nuovo)>0){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_nuovo' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_nuovo="";
$PS="";
}
if(strlen($idCONF)>0){
$idCONF=str_replace(" ","",$idCONF);
$idCONF=str_replace("'","",$idCONF);
$idCONF=str_replace("/","",$idCONF);
$idCONF=str_replace("\\","",$idCONF);
$sql="SELECT * FROM rin_clienti WHERE id = '$idCONF' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$PS="";
$idCONF="";
}
if(strlen($id_cerca_citta)>0){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_cerca_citta' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_cerca_citta="";
$PS="";
}
if(strlen($id_cerca_acqui)>0){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_cerca_acqui' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_cerca_acqui="";
$PS="";
}
if(strlen($id_cerca_telef)>0){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_cerca_telef' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_cerca_telef="";
$PS="";
}
if(strlen($id_cerca_cellu)>0){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_cerca_cellu' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_cerca_cellu="";
$PS="";
}
if(strlen($id_cerca_attiv)>0){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_cerca_attiv' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_cerca_attiv="";
$PS="";
}
if(strlen($id_cerca_nome)>0){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_cerca_nome' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_cerca_nome="";
$PS="";
}
if($id_cerca_id=="notro"){
?>
Warning: Undefined variable $notr in D:\inetpub\webs\rinwebit\Mysql\SchedaVR.php on line 218
NON TROVO: 0){
$sql="SELECT * FROM rin_clienti WHERE id = '$id_cerca_id' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$id_cerca_id="";
$PS="";
}
if(strlen($PartitaIVAold)>0){
$PartitaIVAold=substr($partitaIVAold,1);
$sql="SELECT * FROM rin_clienti WHERE PartitaIVA LIKE '%$PartitaIVAold%' LIMIT 1";
$PartitaIVAold="";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="IDvai") {
$sql="SELECT * FROM rin_clienti WHERE id='$id' ORDER BY id LIMIT 1";
$res=mysql_query($sql,$conn) or die(mysql_error());
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
if ($id!=$arr[id]) {
$notrovo="NON TROVATO";
?> '$rs' ORDER BY RagioneSociale";
$res = mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="Elimina") {
$id=$_POST['id'];
$sql2="SELECT * FROM rin_clienti WHERE id = '$id' limit 1 ";
$res=mysql_query($sql2,$conn) or die(mysql_error());
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
$RagioneSociale=$RagioneSociale=$arr[RagioneSociale];
$sql="DELETE FROM rin_clienti where id = '$id' LIMIT 1";
mysql_query($sql,$conn) or die("Errore cancellazione".mysql_error());
$sql="SELECT * FROM rin_clienti WHERE RagioneSociale > '$RagioneSociale' ORDER BY RagioneSociale asc LIMIT 1";
$res = mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="Ultimo") {
$sql2="SELECT * FROM rin_clienti ORDER BY RagioneSociale desc LIMIT 1";
$res2=mysql_query($sql2,$conn) or die(mysql_error());
$arr=mysql_fetch_array($res2,MYSQL_ASSOC);
}
if($PS=="Primo") {
$sql="SELECT * FROM rin_clienti ORDER BY RagioneSociale asc LIMIT 1";
$res=mysql_query($sql,$conn) or die(mysql_error());
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="avanti_ita") {
$rs=$_POST['rs'];
$sql="SELECT * FROM rin_clienti WHERE Stato='Italia' and RagioneSociale > '$rs' ORDER BY RagioneSociale asc LIMIT 1";
$res = mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="avanti_fra") {
$sql="SELECT * FROM rin_clienti WHERE Stato='Francia' and RagioneSociale > '$rs' ORDER BY RagioneSociale asc LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="avanti_mail_ita") {
$sql="SELECT * FROM rin_clienti WHERE RagioneSociale > '$RagioneSociale' AND Stato = 'ITALIA' AND length(Email) > 4 ORDER BY RagioneSociale asc LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="ULTIMO MAIL IT INVIATO") {
$oggi=date('d-m-y');
echo $oggi;
$sql="SELECT * FROM rin_clienti WHERE Stato like 'ITALIA' AND INSTR(NOTE1,'$oggi') ORDER BY RagioneSociale DESC LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="ConMailItNoInviato") {
$sql="SELECT * FROM rin_clienti WHERE length(Email) > 3 and Stato like 'ITALIA' AND length(NOTE1) > 3 order by RagioneSociale DESC LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="avanti_mail_fra") {
$sql="SELECT * FROM rin_clienti WHERE RagioneSociale > '$RagioneSociale' AND Stato = 'Francia' AND length(Email) > 4 ORDER BY RagioneSociale asc LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="ConMailFrNoInviato") {
$sql="SELECT * FROM rin_clienti WHERE RagioneSociale > '$RagioneSociale' AND Stato = 'Francia' AND length(Email) > 4 AND NOTE1 NOT LIKE '%MailF38%' ORDER BY id asc LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="InviatoMailIt") {
$sql="SELECT * FROM rin_clienti WHERE id > '$id' AND Stato = 'Italia' AND length(Email) > 4 AND NOTE1 LIKE '%M%' ORDER BY id asc LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="InviatoMailFr") {
echo "sssssssssssss";
$sql="SELECT * FROM rin_clienti WHERE id > '$id' AND Stato = 'Francia' AND length(Email) > 4 AND NOTE1 LIKE '%M%' LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="InviaMail3pr") {
$sql="SELECT * FROM rin_clienti WHERE id > '$id' AND Stato = 'Italia' AND length(Email) > 4 AND NOTE1 LIKE '%M%' AND Note NOT LIKE '%-14%' ORDER BY id LIMIT 1";
$res=mysql_query($sql,$conn);
$arr=mysql_fetch_array($res,MYSQL_ASSOC);
}
if($PS=="COPIANOTE") {
$sql2 ="insert into rin_clienti(NOTE3) SELECT Note3 FROM clienti Codice= clienti(Codice)";
mysql_query($sql2) or die("Errore inserimento ".mysql_error());
}
?>
0) {
mysql_query("SET NAMES utf8");
$id=$arr[id];
$Codice=$arr[Codice];
$RagioneSociale=$arr[RagioneSociale];
$rs=$arr[RagioneSociale];
mysql_query("SET NAMES utf8");
$Via=$arr[Via];
$IndirizzoDist=$arr[IndirizzoDist];
$CAP=$arr[CAP];
$CapDist=$arr[CapDist];
$Comune=$arr[Comune];
$CittaDest=$arr[CittaDest];
$Provincia=$arr[Provincia];
$SiglaDest=$arr[SiglaDest];
$Stato=$arr[Stato];
$DescrizionePagamento=$arr[DescrizionePagamento];
$PartitaIVA=$arr[PartitaIVA];
$CodFiscale=$arr[CodFiscale];
$Telefono=$arr[Telefono];
$Cellulare=$arr[Cellulare];
$Fax=$arr[Fax];
$Email=$arr[Email];
$AttivitaPrevalente=$arr[AttivitaPrevalente];
$CodiceUnivoco=$arr[CodiceUnivoco];
$Pec=$arr[Pec];
$NOTE1=$arr[NOTE1];
$NOTE2=$arr[NOTE2];
$NOTE3=$arr[NOTE3];
$_SESSION[id]=$id;
$RagioneSociale = str_replace("'","`",$RagioneSociale);
$rs=$RagioneSociale;
if(strlen($id)>0){$_SESSION[id]=$id;}
}
?>
0){$id=$codi;$codi="";}
$result = mysql_query("SELECT * FROM rin_clienti WHERE Stato='francia'");
$totfra = mysql_num_rows($result);
echo " Francia: ".$totfra;
$result = mysql_query("SELECT * FROM rin_clienti WHERE Stato='svizzera'");
$totsviz = mysql_num_rows($result);
echo " Svizzera: ".$totsviz;
$result = mysql_query("SELECT * FROM rin_clienti WHERE Stato='germania'");
$totgerm = mysql_num_rows($result);
echo " Germania: ".$totgerm;
$result = mysql_query("SELECT * FROM rin_clienti WHERE Stato='austria'");
$totaust = mysql_num_rows($result);
echo " Austria: ".$totaust;
$result = mysql_query("SELECT * FROM rin_clienti WHERE Stato='belgio'");
$totbelg = mysql_num_rows($result);
echo " Belgio: ".$totbelg;
$result = mysql_query("SELECT * FROM clienti WHERE Stato='slovenia'");
$totslov = mysql_num_rows($result);
echo " Slovenia: ".$totslov;
$result = mysql_query("SELECT * FROM rin_clienti WHERE Stato='croazia'");
$totcroa = mysql_num_rows($result);
echo " Croazia: ".$totcroa;
$result = mysql_query("SELECT * FROM rin_clienti WHERE Stato='russia'");
$totruss = mysql_num_rows($result);
echo " Russia: ".$totruss;
$totresto = $totclie - $totital - $totfran - $totsviz - $totgerm - $totaust - $totbelg - $totslov - $totcroa - $totruss;
echo " resto mondo: ".$totresto;
?>
ELENCO CAMPI TABELLA rin_clienti
{$row['Field']} - tipo del campo: {$row['Type']}\n
";
}
mysql_close();
?>