Location: PHPKode > projects > EasyFest > new/add_answer.php
<?php



include_once("include/db_connection.php");
	header("Expires: Thu, 17 May 2001 10:17:17 GMT");    // Date in the past
	header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
	header ("Cache-Control: no-cache, must-revalidate");  // HTTP/1.1
	header ("Pragma: no-cache");                          // HTTP/1.0              
	session_start();
		if($_SESSION["adminloggedIn"] == FALSE){
		header("Location:admin_login.php");
		exit;
	}
include('header.php');
	include('left1.php');?>
    
    
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>add a reply</title>
<meta name="keywords" content="" />
<meta name="Premium Series" content="" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />

<script language="JavaScript" src="gen_validatorv31.js" type="text/javascript"></script>

<title>Untitled Document</title>
</head>

<body>
<div id="wrapper">
	<!-- start page -->
	<div id="page">
    	  <!-- start content -->
        <div id="prtCnt" align="center">
		<div id="content" align="center">
		  <div class="post">
	    <h2 class="title">&nbsp;</h2>
	    <div class="entry"><?php
// Get value of id that sent from hidden field
$id=$_POST['id'];

$tbl_name="forum_answer"; // Table name   
 $UserName = $_SESSION['UserName'];

// Find highest answer number.
$sql="SELECT MAX(a_id) AS Maxa_id FROM $tbl_name WHERE question_id='$id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);

// add + 1 to highest answer number and keep it in variable name "$Max_id". if there no answer yet set it = 1
 if ($rows) {
     $Max_id = $rows['Maxa_id']+1;
            }
  else {
     $Max_id = 1;
       }

// get values that sent from form
//$a_name=$_POST['a_name'];
$a_email=$_POST['a_email'];
$a_answer=$_POST['a_answer'];
//$a_name=$_POST['a_name'];

$datetime=date("d/m/y H:i:s"); // create date and time

// Insert answer
if($a_answer==null)
    {
       echo "Please enter the answer properly!!!";
	   echo "<a href=main_forum.php> Choose the topic to answer</a>";
    }
    else
    {	
// Insert answer
       $sql2="INSERT INTO $tbl_name(question_id, a_id, a_name, a_email, a_answer, a_datetime)VALUES('$id', '$Max_id', '$UserName', '$a_email', '$a_answer',    '$datetime')";
       $result2=mysql_query($sql2);
       
	   if($result2){
                    echo "Successful<BR>";
                    echo "<a href='view_topic.php?id=".$id."'>View your reply</a>";

// If added new answer, add value +1 in reply column
                    $tbl_name2="forum_question";
                    $sql3="UPDATE $tbl_name2 SET reply='$Max_id' WHERE id='$id'";
                    $result3=mysql_query($sql3);

                   }
       else {
                 echo "ERROR";
            }
     }
mysql_close();
?>
                    </p>
				</div>
		  </div>
		</div>
        </div>
        <!-- end content -->
		<!-- start sidebars -->
		<!-- end sidebars -->
	  <div style="clear: both;">&nbsp;</div>
	</div>
	<!-- end page -->
</div>
</html>
<?php
	include('footer.php');
?>
Return current item: EasyFest