rendered paste body<body><table width="800" border="0" align="center"> <tr> <th scope="col">Product Name</th> <th scope="col">Image</th> <th scope="col">Media type</th> <th scope="col">Genre</th> <th scope="col">Price</th> </tr> <?php // Connect to COM driver $conn = new COM("ADODB.Connection") or die("Cannot start ADO"); // Connect to database $dbpath = getcwd().'\\'."trinity.mdb"; $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$dbpath"); // Use SQL statement to build recordset from one or more tables $rs = $conn->Execute ("SELECT * FROM Products WHERE CategoryID = '" . $_REQUEST['media_type'] . "' AND Genre = '" .$_REQUEST['genre'] . "';");if($rs->Fields->Count() > 0) {while (!$rs->EOF) {?> <tr> <td><a href="item.php?ID=<?php echo $rs->Fields('ProductID')->Value;?>"><?php echo $rs->Fields('ProductName')->Value;?></td> <td><img src="<?php echo $rs->Fields('Image')->Value;?>" alt="<?php echo 'ProductName';?>"></td> <td><?php echo $rs->Fields('CategoryID')->Value;?></td> <td><?php echo $rs->Fields("Genre")->Value;?></td> <td>$<?php echo $rs->Fields("UnitPrice")->Value;?></td> </tr> <?php $rs->MoveNext(); }} else { echo "No results found, please try a different search";}?></table>