<html><body bgcolor="#333333" style="color:white; font-family:Verdana, Geneva, sans-serif;" > <table border="1" bordercolor="#000000" bgcolor="#00FFFF" style="color:black" width="985px"> <tr> <th width="300px">Product</th> <th width="300px">Part #</th> <th width="300px">Supplier</th> <th>Amount</th> </tr> <? $host = "localhost";$user = "root";$pass = "";$database = "products";$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");mysql_select_db($database, $linkID) or die("Could not find database.");$query = "SELECT * FROM products ORDER BY supplier, product";$resultID = mysql_query($query, $linkID) or die("Data not found.");while($row = mysql_fetch_array($resultID)) { $fok = $row['id']; $amount = $_POST[$fok] . "</td>";if ($amount != 0) { echo "<tr><td>"; echo $row['Product'] . "</td><td>"; echo $row['Part_Number'] . "</td><td>"; echo $row['Supplier'] . "</td><td>"; echo $amount; echo "</tr>"; } } echo "</table>"; ?> </html>