bonjour,
si je fais ce que tu me dis (chose que j'avais déjà essayé, c'est d'ailleurs pour ça que je demande de l'aide)

<?
$sqlconnect=odbc_connect($dsn,$username,$password);
$sqlquery="SELECT Products.ProductName, Products.ProductDesc, Products.type, Stock.Quality, SUM(Stock.Quantity)
FROM Products, Stock
where Products.ProductName=Stock.ProductName and Products.Type <> 'S'
Group by Products.ProductName, Products.ProductDesc, Products.type, Stock.Quality, Stock.Quantity
order by Products.ProductName, Products.Type ;" or die (mysql_error());
$process=odbc_exec($sqlconnect, $sqlquery);
?>

en rajoutant donc le code suivant :
<?php while(odbc_fetch_row($process)){ $ProductName = odbc_result($process,"ProductName"); $ProductDesc = odbc_result($process,"ProductDesc"); $Type = odbc_result($process,"Type"); $Quality = odbc_result($process,"Quality"); $Quantity = odbc_result($process,"Quantity"); ?>
<tr class="tab05">
<td><?php echo $ProductName ; ?></td>
<td><?php echo $ProductDesc ; ?></td>
<td><div align="center"><?php echo $Quality ; ?></div></td>
<td><div align="center"><?php echo $Quantity ; ?></div></td>
<td><div align="center"><?php echo $Type ; ?></div></td>
</tr><?php }odbc_close($sqlconnect); ?>

j'ai l'erreur suivante :

Warning: odbc_result(): Field Quantity not found in c:\program files\easyphp1-8\www\eurosource-intranet\references\print_stock.php on line 43

la ligne 43 étant :

<?php while(odbc_fetch_row($process)){ $ProductName = odbc_result($process,"ProductName"); $ProductDesc = odbc_result($process,"ProductDesc"); $Type = odbc_result($process,"Type"); $Quality = odbc_result($process,"Quality"); $Quantity = odbc_result($process,"Quantity"); ?>

Merci de m'aider SVP...