<? $query = "select * from dream_posting where catagory='$catagory'"; $result = ora_parse($cursor, $query); $result = ora_exec($cursor); echo "<tr bgcolor=\"#7093DB\"><td>Product Name</td><td width=50%>Description</td><td>First Bid</td></tr>"; // fetch rows from cursor while (ora_fetch($cursor)) { $pid = ora_getcolumn($cursor, 0); $name = ora_getcolumn($cursor, 1); $description = ora_getcolumn($cursor, 7); $firstbid = ora_getcolumn($cursor, 5); printf("<tr bgcolor=\"#C0D9D9\"><td><a href=\"product.php3?pid=%s&catagory=%s\">%s</a></td><td>%s</td><td>%s</td></tr>", $pid, $catagory, $name, $description, $firstbid); } echo "</table>"; ora_close($cursor); ora_logoff($connHandle); ?>