eclaireobscure
ok voici mon code
<form action="medical_sale.php" method="post">
<?php
include('connectDB.php');
$query="SELECT * FROM product where ptype='Medical' order by product.pname";
$result= mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
echo $num ; echo (" Medical Products");
?>
</strong></h2>
<table width="764" border="1" align="center" cellpadding="1" cellspacing="1" >
<tr valign="top">
<th>Code</th>
<th>Name</th>
<th>Vendor</th>
<th>Description</th>
<th>Price </th>
<th></th>
</tr>
<?php
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"pcode");
$f2=mysql_result($result,$i,"pname");
$f3=mysql_result($result,$i,"pvendor");
$f4=mysql_result($result,$i,"psize");
$f5=mysql_result($result,$i,"pprice");
?>
<tr>
<td><a href="medical_sale.php" target="_self" ><font face="Arial, Helvetica, sans-serif" size="1"><?php echo $f1; ?></font></a></td>
<td><a href="medical_sale.php" target="_self"><font face="Arial, Helvetica, sans-serif" size="1"><?php echo $f2; ?></font></a></td>
<td><a href="medical_sale.php" target="_self"><font face="Arial, Helvetica, sans-serif" size="1"><?php echo $f3; ?></font></a></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif" size="1"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><input name="cart" type="submit" value="Add to Cart" /></font></td>
</tr>
<?php
$i++;
}
?>
</form>
</td>
</tr>
</table>