<? 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>