Example #1
0
					$nomemarcadb=@mysql_result($querymarca,0,1);
					
					//note del prodotto
					$querynote=mysql_query("select * from note where idpreventivo='".$idvisualizza."' and idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!");
					$notedb=@mysql_result($querynote,0,3);
					
					//prezzo
					$queryprezzo=mysql_query("select * from prezzi where idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!");
					$prezzodb=@mysql_result($queryprezzo,0,2);
					$totale=$totale+$prezzodb;
					
					//misure del prod
					$misura="L. ".mysql_result($queryprod,0,4)." P. ".mysql_result($queryprod,0,5)." H. ".mysql_result($queryprod,0,6);
?>					<table  border="0" width="900" cellpadding="0" cellspacing="0" style="font-family: Arial; margin-left: 10px;">
						<tr>
							<td height="40" width="900" style="padding-left: 20px; padding-top: 10px; border: 1px solid #000;"><? print "<div style=\"float: left; width: 750px;\">".puliscitesto(strtoupper($nomemarcadb))." - ".puliscitesto($nomeproddb)."</div><div style=\"font-family: Arial; float: left; font-weight: bold;\">&euro;. ".sistemaprezzo($prezzodb)."</div>"; ?></td>
						</tr>
						<tr>
							<td height="36" width="890" style="padding-left: 10px; border: 1px solid #000; font-size: 12px;">
								<div style="width: 890px; height: 92px; overflow: hidden;">
								<? print utf8_encode(puliscitesto($descproddb,300)); ?>
<? 								if($misura!="L. 0 P. 0 H. 0"){
									print $misura;

								}
?>								</div>
							</td>	
						</tr>
					</table>	
					<table  style="font-family: Arial;" border="0" cellpadding="0" cellspacing="0" style="margin-left: 15px; padding-left: 20px; font-weight: bold;">					
						<tr>
					$nomemarcadb=@mysql_result($querymarca,0,1);
					
					//note del prodotto
					$querynote=mysql_query("select * from note where idpreventivo='".$idvisualizza."' and idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!");
					$notedb=@mysql_result($querynote,0,3);
					
					//prezzo
					$queryprezzo=mysql_query("select * from prezzi where idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!");
					$prezzodb=@mysql_result($queryprezzo,0,2);
					
					//misure del prod
					$misura="L. ".mysql_result($queryprod,0,5)." P. ".mysql_result($queryprod,0,6)." H. ".mysql_result($queryprod,0,7);
?>					<div style="margin-bottom: 50px; overflow: hidden; width: 950px; height: <? if($cont>1){ print "1343px; background: url('../s-admin/immagini/sfondoanteprima.jpg') no-repeat; padding-top: 30px;";}else{ print "1034px;";}?>;">
					<table  border="0" width="900" cellpadding="0" cellspacing="0" style="font-family: Arial; margin-left: <? if($cont>1){ print "20px;";}else{ print "15px;";}?>">
						<tr>
							<td height="40" width="900" style="padding-left: 20px; padding-top: 10px; background: url('../s-admin/immagini/riquadro4.jpg') no-repeat;"><? print "<div style=\"float: left; width: 750px;\">".puliscitesto(strtoupper($nomemarcadb))." - ".puliscitesto($nomeproddb)."</div><div style=\"font-family: Arial; float: left; font-weight: bold;\">€. ".sistemaprezzo($prezzodb)."</div>"; ?></td>
						</tr>
						<tr>
							<td height="36" width="890" style="padding-left: 20px;">
								<div style="height: 100px; width: 890px; overflow: hidden;">
								<? print puliscitesto($descproddb,300); ?>
<? 								if($misura!="L. 0 P. 0 H. 0"){
									print $misura;

								}
?>								</div>
							</td>	
						</tr>
					</table>	
					<table border="0" width="900" cellpadding="0" cellspacing="0" style="margin-left: 15px; ">
						<tr>