All pastes #197352 Raw Edit

Something

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