Posto la pagina

<html>
<?php
define("PAGE_TITLE", "Customer Update");
define("PHP_FILE_NAME", "db2_update1.php")
?>

<head>

<title><?= PAGE_TITLE . " - " . PHP_FILE_NAME; ?></title>


<style type="text/css">
body {margin:0px}
body{font: 76%/1.1 Arial,Verdana,sans-serif}
div.box{width:0px;width /**/:1020px;
height:0px;height /**/: 439px;
overflow:auto;padding: 0px;
border:1px solid #000000;border-right:3 solid;
background: #999999;
repeat-x fixed top left}

div.box p{margin-top:0}
.style14 {
font-size: 24px;
font-weight: bold;
}


body {
background-attachment:"fixed";
background-repeat:"repeat";
cursor: Default; text-decoration: none;
scrollbar-arrow-color: #000000;
scrollbar-base-color: #666666;
scrollbar-dark-shadow-color: #666666;
scrollbar-track-color: #666666;
scrollbar-face-color: #666666;
scrollbar-shadow-color: #999999;
scrollbar-highlight-color: #999999;
scrollbar-3d-light-color: #666666;
backgroundcolor: #666666
}


</style>

</head>

<body style="overflow:hidden;" bgcolor="#666666">

<table border="0" width="100%" align="center">
<tr>
<td height="72"></td>

</tr>
<tr>
<td>
<div class="box" align="left">

<?php

/* Apertura connessione al database*/
include("connection.inc");

/* Costruzione dello statement SQL da eseguire */

$srvcas = N;

$sql = "select *
from ACSSI_DAT.srvrq00f
where srvcas = '".$srvcas."'
order by srvdat desc ";


/* Esecuzione diretta dello stament SQL */
$stmt = db2_exec($dbh, $sql, array('cursor' => DB2_SCROLLABLE));

print '
<table border=1 width="6000" height="61" cellpadding=14 cellspacing=0 bordercolor="#666666">';

?>
<tr>

<td align="center"><font face="Arial"><?php echo(Cliente);?> </font></td>
<td><font face="Arial"><?php echo(Num);?></font></td>
<td><font face="Arial"><?php echo(Serial);?></font></td>
<td><font face="Arial"><?php echo(Modello);?></font></td>
<td><font face="Arial"><?php echo(Partizione);?></font></td>
<td><font face="Arial"><?php echo(Prodotto);?></font></td>
<td><font face="Arial"><?php echo(Vr);?></font></td>
<td><font face="Arial"><?php echo(Bld);?></font></td>
<td><font face="Arial"><?php echo(Rls);?></font></td>
<td><font face="Arial"><?php echo(Pck);?></font></td>
<td><font face="Arial"><?php echo(Richiedente);?></font></td>
<td><font face="Arial"><?php echo(Data);?></font></td>
<td><font face="Arial"><?php echo(Motivo);?></font></td>


</tr>




<?php
while ($row = db2_fetch_array($stmt)) {
if (!$row=="") {
$customerSRVCLI = $row[7];
$customerSRVNUM = $row[8];
$customerSRVSRN = $row[11];
$customerSRVMOD = $row[12];
$customerSRVNSP = $row[13];
$customerSRVPRO = $row[9];
$customerSRVVER = $row[10];
$customerSRVBLD = $row[42];
$customerSRVREL = $row[40];
$customerSRVASP = $row[41];
$customerSRVPER = $row[17];
$customerSRVDAT = $row[18];
$customerSRVMOT = $row[20];
$customerSRVSOL = $row[22];
?>
<tr>
<td align=left" valign="top" width="10"> <font size="2" face="Arial">
<?php echo($customerSRVCLI);?>
</font></td>
<td align="left" valign="top" width="2"><font size="2" face="Arial"><?php echo($customerSRVNUM);?></font></td>
<td align="left" valign="top" width="1"><font size="2" face="Arial"><?php echo($customerSRVSRN);?></font></td>
<td align="left" valign="top" width="85"><font size="2" face="Arial"><?php echo($customerSRVMOD);?></font></td>
<td align="left" valign="top" width="1"><font size="2" face="Arial"><?php echo($customerSRVNSP);?></font></td>
<td align="left" valign="top" width="1"><font size="2" face="Arial"><?php echo($customerSRVPRO);?></font></td>
<td align="left" valign="top" width="1"><font size="2" face="Arial"><?php echo($customerSRVVER);?></font></td>
<td align="left" valign="top" width="1"><font size="2" face="Arial"><?php echo($customerSRVBLD);?></font></td>
<td align="left" valign="top" width="1"><font size="2" face="Arial"><?php echo($customerSRVREL);?></font></td>
<td align="left" valign="top" width="1"><font size="2" face="Arial"><?php echo($customerSRVASP);?></font></td>
<td align="left" valign="top" width="170" ><font size="2" face="Arial"><?php echo($customerSRVPER);?></font></td>
<td align="left" valign="top" width="75"><font size="2" face="Arial"><?php echo($customerSRVDAT);?></font></td>
<td align="left" valign="top" width="980"><font size="2" face="Arial"><?php echo($customerSRVMOT);?></font></td>
<td align="left" valign="top" width="980"><font size="2" face="Arial"><?php echo($customerSRVSOL);?></font></td>
</tr>

<?php
}
}


print '</table>
';


?>


</div>
</td>
</tr>
</table>
</body>
</html>