<![CDATA[
<?
$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);
?>
]]></plaintext></body>