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) { ?> '; } ?>
Product Name Image Media type Genre Price
<?php echo $res['ProductName'];?> $

Your search returned no results. Sux2BeYou.