rendered paste 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'] . "';");$rows =0;$results = array();while(!$rs->EOF) { for($i=0;$i<$rs->Fields->count;$i++) { $rsf = $rs->Fields($i); $rtn[$rows][$rsf->Name] = $rsf->value; } $rows++; $rs->MoveNext();}if($rows > 0) { foreach ($result as $res) { ?> <tr> <td><a href="item.php?ID=<?php echo $res['ProductID'];?>"><?php echo $res['ProductName'];?></td> <td><img src="<?php echo $res['Image'];?>" alt="<?php echo $res['ProductName'];?>"></td> <td><?php echo $res['CategoryID'];?></td> <td><?php echo $res["Genre"];?></td> <td>$<?php echo $res["UnitPrice"];?></td> </tr> <?php }} else { echo '<tr><td><p>Your search returned no results. Sux2BeYou.</p></td></tr>';}?></table>