Hi all,
When filling the below form I use error checking to check that it has been filled out.
However, if the textarea is blank and the error message appears, the Hidden Field loses its value.
Why is this?
Thanks.
// Set Variables
$issue_id = $_GET['id'];
$fund_number = $_GET['value'];
// Connect to DB
include('../db_connect.php');
// Select Query
$query = "SELECT * ".
"FROM issues ".
"WHERE issue_ID = '$issue_id' ".
"AND fund_number = '$fund_number'";
//echo $query;
$result = mssql_query($query) or die('Select Error');
while($row = mssql_fetch_array($result))
{
$fund_name = $row['fund_name'];
}
?>
<form action="suggest_resolution2.php" name="frm_res" id="frm_res" method="post">
<p>
<label for="fund_number">Fund #:</label>
<input type="hidden" name="fund_number" id="fund_number" value="<?php echo $fund_number; ?>" />
</p>
<p>
<?php if(isset($error_message['res'])) { echo $error_message['res'].'<br />'; }?>
<label for="res">Resolution:</label>
<textarea cols="30" rows="10" name="res" id="res"></textarea>
</p>
</form>
Once form is submitted...
<?php
if(isset($_POST['submit']))
{
// set variables
$fund_number = $_POST['fund_number'];
$res = $_POST['res'];
// declare an empty error array
$error_message = array();
/*************************
Form Error Checking
*************************/
if(!$res)
{
$error_message['res'] ='Please Enter Suggested Resolution';
}
/*********************************
If No Form Errors
*********************************/
if(count($error_message) == 0)
{
// connect to DB
include('../db_connect.php');
// Perform Query
$query = "UPDATE issues ".
"SET resolution = '$res' ".
"WHERE fund_number = '$fund_number'";
echo $query;
$result = mssql_query($query) or die('Insert Query Error');
if($result)
{
// declare an empty error array
$result_message = array();
$result_message['result'] = '<p>Resolution Successfully Posted.</p>';
}
} // end if count
} // end isset
?>
