session_start(); include"../include/conn.php"; //include_once("../../employer/classes/rndPass.class.php"); include"../include/statictable.php"; $userId=$_SESSION["userId"]; $loginid=$_SESSION["loginid"]; if(!isset($userId)) header("Location: ../profile/newaccount.php?a=displayLogin"); $sql="select a.*,b.* from CSS_SUBJECT_CHOOSED a,CSS_APP_SUBJECT b where CSS_APPLICANT_ID=$_GET[userId_d] and a.CSS_SUBJECT_ID=b.CSS_SUBJECT_ID and CSS_ADVERTISEMENT_ID=$_GET[jid]"; //echo $sql; $rs = OCIParse($conn,$sql); OCIExecute($rs); ?>