<![CDATA[
<? include("connect.inc") ?>
<? $query = "select cid from dream_customer where username='$Username' and password='$Password'";
$result = ora_parse($cursor, $query);
$result = ora_exec($cursor);
if(!ora_fetch($cursor)) {
$message="<font color=red><b>Login Fail. Please click back to check you username and password</b></font>";
}
else {
$cid = ora_getcolumn($cursor,0);
if(!$category) {
$message="<font color=red><b>Please pick one of the catagory. You can click back button.</font>";
}
else {
$message = "Thank you for posting product at dreamland. <font color=\"#7093DB\">$Product</font> have been posted.";
$query = "select count(*) from dream_posting";
$result = ora_parse($cursor, $query);
$result = ora_exec($cursor);
ora_fetch($cursor);
$pid = 100001 + ora_getcolumn($cursor,0);
$startdate = $startday."-".$startmonth."-00";
$enddate = $endday."-".$endmonth."-00";
$query = "insert into dream_posting values('$pid','$Product','$startdate','$enddate','$Quantity','$firstbid','$category','$description','$city','$state','$cid')";
$result = ora_parse($cursor, $query);
$result = ora_exec($cursor);
ora_close($cursor);
ora_logoff($connHandle);
?>
<html>
<body background="cdbkgnd.jpg">
<center>
<img border="0" src="images/front_top.jpg" width="600" height="100">
</center>
<blockquote>
<h3><? echo $message; ?></h3>
<center>
<br><br>Click <a href="default.htm">Dream</a> </center>
</blockquote>
</body>
</html>
]]></plaintext></body>