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) { ?> MoveNext(); } } else { echo "No results found, please try a different search"; } ?>

Product Name	Image	Media type	Genre	Price
Fields('ProductName')->Value;?>		Fields('CategoryID')->Value;?>	Fields("Genre")->Value;?>	$Fields("UnitPrice")->Value;?>