 <?php
 requireonce(1 database.php1);
 $query = 'SELECT *
 FROH categories 
ORDER BY categorylD';
 $categorles = $db->query($query);
 ?>
 How to use PHP with MySQL 
<!D0CTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
 "http://www.w3.org/TR/xhtmll/DTD/xhtmll-transitional.dtd"> 
chtml xmlns="ht tp://www.w3.org/19 9 9/xhtml">
 <!-- the head section -->
 <head>
 <title>Task4b</title>
 clink rel="stylesheet" type="text/css" href="main.css" />
 </head>
 <!-- the body section -->
 <body>
 <div id="page">
 <div id="header">
 <hl>Product Manager</hl>
 </div>
 <div id="main">
 <hl>Add Product</hl>
 <form action="add_product.php" method="post" 
id="add_product_form" >
 <label>Category:</label>
 <select name="category_id">
 <?php foreach ($categories as $category) : ?>
 «option value="<?php echo $category['categorylD']; ?>"> 
<?php echo $category['categoryName'] ; ?>
 </option>
 <?php endforeach; ?>
 </select>
 <br />
  <label>Code:</label>
 cinput type="input" name="code" />
 <br />
 <label>Name:</label>
 <input type="input" name="name" />
 <br />
 <label>List Price:</label>
 <input type="input" name="price" />
 <br />
 How to use PHP with MySQL 
<label>&nbsp;</label>
 <input type="submit" value="Add Product" />
 <br />
 </form>
 <pxa href="index.php">View Product List</ax/p>
 </div><!-- end main -->
 <div id="footer">
 <p>&copy; <?php echo date("Y"); ?>Task4b, assignment 4.</p> 
</div>
 </div><!-- end page -->
 </body>
 </html>