1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
<body>
<? $cnx = odbc_connect(" DEMAT" , "" , "" ) or die ("Connexion à la base de donnée impossible");?>
<form action="cat8.php" method="POST">
<h4>
analyse voulue :
<select name="demat" id="demat">
<?
echo "<option value='declaration'";
if($_POST['demat'] == 'declaration')
echo " SELECTED";
echo ">Déclaration</option>";
echo "<option value='paiement'";
if($_POST['demat'] == 'paiement')
echo " SELECTED";
echo ">Paiement</option>";
?>
</select>
<input type="button" value="Ok" onclick="submit()" >
<p>
valeur :
<?
if($_POST['demat'] == 'declaration')
{
$res1 = odbc_exec($cnx, "SELECT Count(dec.NO_EXTERNE) FROM dec WHERE dec.DIRRES_D=1;");
echo odbc_result($res1, 1 );
}
else
{
$res = odbc_exec($cnx, "SELECT Count(pai.NO_EXTERNE) FROM pai WHERE pai.CATEGORIE=80 AND pai.MAX_DIRRES=1;");
echo odbc_result($res, 1 );
}
?>
|
Partager