session_start(); global $scode; $linkID = mysql_connect("localhost", "root", "zangtang"); mysql_select_db("SciPark"); $query0 = "SELECT * FROM AdminLogin WHERE `AdminLogin`='$login'"; $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error()); $tung0=mysql_affected_rows(); $i=0; $j=0; if(isset($_SESSION['AdminLogin'])) { $ExhbtCode = $_SESSION["ExhbtCode"]; //echo $_SESSION["ExhbtCode"]; // $DelExhbt = $_POST['$ExhbtId']; echo $DelExhbt; $query0 = "SELECT * FROM ExhbtMaster where ExhbtId = '$ExhbtCode' "; //echo $query0; $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error()); $tung0=mysql_affected_rows(); if($tung0 != 0) { while ($r = mysql_fetch_array($result0)) { $ExhbtName = $r["ExhbtName"]; $_SESSION["ItemType"] = $ItemType ; } $Fdate = date("Y-m-d"); $Tag = "0"; $ExtraInfo = ""; $query0 = "INSERT INTO DelExhbts SELECT * FROM ExhbtMaster WHERE ExhbtId = '$ExhbtCode'"; //echo $query0; $result1 = mysql_db_query("SciPark", $query0) or die ("could not connect to database".mysql_error()); $tung1=mysql_affected_rows(); if($tung1 != 0) { $qry0 = "DELETE FROM ExhbtMaster WHERE ExhbtId = '$ExhbtCode'"; $result1 = mysql_db_query("SciPark", $qry0) or die ("could not connect to database".mysql_error()); //echo $qry0; $tung1=mysql_affected_rows(); } ?>