All pastes #197311 Raw Edit

Miscellany

public php v1 · immutable
·published 2006-10-11 06:47 UTC
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>