[RESOLVED] need help...urgent......

chinna

need help...urgent......
i try to do edit button....and this is my code

<?php 
//session_start();

if (isset($_REQUEST['edit'])){

  if(@$_REQUEST['purpose2'] != $_SESSION['purpose']) {

   $purpose2 = $_REQUEST['purpose2'];

   }

$query = "UPDATE voucher SET purpose = '".$_REQUEST['purpose2']."' WHERE emp_1 = '".$_SESSION['emp_1']."'";
mysql_query($query) or die('Error, insert query failed');}
?>

PHP Code:
i click the edit buutin...the data in purpose field is dissappear...it supposed replace with new value...(purpose)...but it empty...no data in that field,,,someone please help to solve...realy urgent...my project stuck because of this.....thank you in advanced

hates make waste

scrupul0us

u have session start commented out, but then try to use session variables in your script...

theres a start

also your topic title isnt very informative... gives users no insight to what your problem is at all

chinna

i already call out my session at top off the page....so..that why comment out it....

scrupul0us

well then the code u have supplied is useless... we need to see your whole script to know what is wrong

chinna

here i submit full code for that page...

<?php
session_start();
include "db1.php"

?>



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>aftersave.php</title>
<style type="text/css">
<!--
-->
h3{background-color:#CCCCCC;}
.style3 {font-size: 9px}
</style></head>

<body>
<table width="760" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="160">Prepared By </td>
    <td width="220"><? if(isset($_SESSION['prepare_by'])) {  echo $_SESSION['prepare_by'];} ?> </td>
    <td width="160">Emp No </td>
    <td width="220"><? if(isset($_SESSION['emp_1'])) {  echo $_SESSION['emp_1'];} ?></td>
  </tr>
  <tr>
    <td>E-mail Address </td>
    <td><? if(isset($_SESSION['email'])) {  echo $_SESSION['email'];} ?></td>
    <td>Designation</td>
    <td><? if(isset($_SESSION['designation'])) {  echo $_SESSION['designation'];} ?></td>
  </tr>
  <tr>
    <td>Date/Time</td>
    <td><?php echo date ("m/d/Y ");echo date ("g:i a")?></td>
    <td>Dept </td>
    <td><? if(isset($_SESSION['department'])) {  echo $_SESSION['department'];} ?></td>
  </tr>
  <tr>
    <td>Sect Manager </td>
    <td><? if(isset($_SESSION['selectmanager'])) {  echo $_SESSION['selectmanager'];} ?></td>
  </tr>
</table>
<h3>Voucher Details</h3>

<table width="400" height="120" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="160" height="54">Purpose</td>
    <td width="240"><textarea name="purpose2"  width="300"><? if(isset($_SESSION['purpose'])) {  echo $_SESSION['purpose'];} ?>
    </textarea><br /></td>
  </tr>
  <tr>
    <td height="22">Pay to </td>
    <td><input name="text" type="text" value="<? if(isset($_SESSION['pay_to'])) {  echo $_SESSION['pay_to'];} ?>" /></td>
  </tr>
  <tr>
    <td height="22">Employee No </td>
    <td><input name="text" type="text" value="<? if(isset($_SESSION['emp_2'])) {  echo $_SESSION['emp_2'];} ?>" /></td>
  </tr>
  <tr>
    <td height="22">ECER</td>
    <td><input name="text" type="text" value="<? if(isset($_SESSION['ecer'])) {  echo $_SESSION['ecer'];} ?>" /></td>
  </tr>
</table><br />
<FORM NAME="edit" METHOD="POST" ACTION="">
<input type="submit" name="edit" id="edit" value="EDIT" />
<?php 
//session_start();

if (isset($_REQUEST['edit'])){

  if(@$_REQUEST['purpose2'] != $_SESSION['purpose']) {

   $purpose2 =@$_REQUEST['purpose2'];
   @$_SESSION['purpose2'] = @$_REQUEST['purpose'];

   }

$query = "UPDATE voucher SET purpose = '".$_REQUEST['purpose2']."' WHERE emp_1 = '".$_SESSION['emp_1']."'";
mysql_query($query) or die('Error, insert query failed');

}
?>



</body>
</html>

hates make waste

bradgrafelman

Please do not cross-post the same topic across multiple boards. Thanks.