[SOLVED] Going Nuts! qry update aint working?
Posted: Tue Mar 29, 2005 1:45 pm
following is the complete code of my "test.php" doc. what i want to see happen is that the user selects the yes option and then inputs the date from the icon next to it.
Once the input is selected and the update is done, it shows the recently inputed values. and then doesnt give the user the option to enter it again.
kind of a write once module. Help!
feyd | Please review how to post code using
Once the input is selected and the update is done, it shows the recently inputed values. and then doesnt give the user the option to enter it again.
kind of a write once module. Help!
Code: Select all
<?php
include ("opendatabase.php");
$ur_file_id=5;
//start of claim update
if ( $pageaction == "clmupdate") {
$update_status = ", Claim Information updated" ;
$query="update claims SET q1=".$updt_q1.", q2=".$updt_q2.", q3=".$updt_q3.", q4=".$updt_q4.", q4a=".$updt_q4a.",
q1_date=".$updt_q1_date.", q2_date=".$updt_q2_date.", q3_date=".$updt_q3_date.", q4_date=".$updt_q4_date."
WHERE ur_file_id=".$urfile ;
$result = mysql_query($query);
}
//end of claim update
//start of normal page rendering.
$query = "select * from claims where ur_adjuster_no =4 and ur_file_id=5" ;
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
// now assign the questionaire fields to temp variables for proper visual coding.
$page_q1 = $row['q1'];
$page_q2 = $row['q2'];
$page_q3 = $row['q3'];
$page_q4 = $row['q4'];
$page_q4a = $row['q4a'];
$page_q1_date = $row['q1_date'];
$page_q2_date = $row['q2_date'];
$page_q3_date = $row['q3_date'];
$page_q4_date = $row['q4_date'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Universal Risk Claims Detail Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style3 {color: #FFFFFF}
.style4 {font-size: 24px}
.style5 {font-size: 36px}
.style6 {font-size: 18px}
body {
margin-left: 0px;
margin-top: 1px;
margin-right: 0px;
margin-bottom: 0px;
}
.style7 {
color: #006666;
font-size: 24px;
}
.style8 {font-size: 12px}
input
{
border: 1px solid #000000;
background: #DDDDDD;
}
select
{
border: 1px solid #000000;
background: #DDDDDD;
font-family: verdana,helvetica,arial,sans-serif;
font-size: 10px;
}
-->
</style>
<script language="JavaScript" src="calendar1.js"></script>
</head>
<body>
<table width="800" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="10" rowspan="6" align="left" valign="top"> </td>
<td width="25" rowspan="6" align="left" valign="top" bgcolor="#9E0B0E"> </td>
<td width="5" rowspan="6" align="left" valign="top"> </td>
<td width="730" bgcolor="#006666"><span class="style3"> <span class="style4">Status System</span> </span></td>
<td width="5" rowspan="6" align="left" valign="top"> </td>
<td width="25" rowspan="6" align="left" valign="top" bgcolor="#9E0B0E"> </td>
</tr>
<tr>
<td height="2" align="left" valign="top"></td>
</tr>
<tr>
<td width="730" align="center" valign="top" bgcolor="#9E0B0E"><div align="center" class="style3 style6">Claim Detail Page <? echo $update_status ; ?> </div></td>
</tr>
<tr>
<td height="15" align="left" valign="top"></td>
</tr>
<tr>
<td height="20" align="left" valign="top"><table width="730" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td colspan="6"><div align="left"> </div></td>
</tr>
<tr>
<td class="style8">Claim Assignment Type </td>
<td colspan="3" align="left" valign="top"><span class="style8"><? echo $row['claim_assignment_type'] ;?></span></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="6"> </td>
</tr>
<tr align="left" valign="top">
<td height="100" colspan="6">
<form name="adjdetail" action="test.php" method="post">
<table width="730" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25" align="left" valign="top" class="style8">1.</td>
<td width="340" align="left" valign="top" class="style8"> Has initial contact been made with the insured? </td>
<td width="10" align="left" valign="top"> </td>
<td width="100" align="left" valign="top"><span class="style8"><? if ($page_q1_date == 0) {?><input type="radio" name="updt_q1" value="NO" checked>NO<input type="radio" name="updt_q1" value="YES">Yes<? } else { echo $page_q1; ?><input type="hidden" name="$updt_q1" value="<? echo $page_q1; ?>"><? } ?></span></td>
<td width="30" align="right" valign="top" class="style8">Date: </td>
<td width="150" align="left" valign="top" class="style8"><? if ($page_q1_date == 0) {?><input type="text" name="updt_q1_date" value="" size="10"> <a href="javascript:cal1.popup();"><img src="../images/img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a><? } else {echo $page_q1_date ; ?><input type="hidden" name="updt_q1_date" value="<? echo $page_q1_date ; ?>"><? } ?></td>
<td width="75" align="left" valign="top"> </td>
</tr>
<tr>
<td class="style8">2.</td>
<td class="style8"> If No, contact attempted? </td>
<td> </td>
<td><span class="style8"><? if ($page_q2_date == 0) {?><input type="radio" name="updt_q2" value="NO" checked>NO<input type="radio" name="updt_q2" value="YES">Yes<? } else { echo $page_q2; ?><input type="hidden" name="$updt_q2" value="<? echo $page_q2; ?>"><? } ?></span></td>
<td align="right" valign="top"><span class="style8">Date: </span></td>
<td align="left" valign="top"><span class="style8"><? if ($page_q2_date == 0) {?><input type="text" name="updt_q2_date" value="" size="10"> <a href="javascript:cal2.popup();"><img src="../images/img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a><? } else {echo $page_q2_date ; ?><input type="hidden" name="updt_q2_date" value="<? echo $page_q2_date ; ?>"><? } ?></span></td>
<td> </td>
</tr>
<tr>
<td class="style8">3.</td>
<td class="style8"> Inspected/Scoped ? </td>
<td> </td>
<td><span class="style8"><? if ($page_q3_date == 0) {?><input type="radio" name="updt_q3" value="NO" checked>NO<input type="radio" name="updt_q3" value="YES">Yes<? } else { echo $page_q3; ?><input type="hidden" name="$updt_q3" value="<? echo $page_q3; ?>"><? } ?></span></td>
<td align="right" valign="top"><span class="style8">Date: </span></td>
<td align="left" valign="top"><span class="style8"><? if ($page_q3_date == 0) {?><input type="text" name="updt_q3_date" value="" size="10"> <a href="javascript:cal3.popup();"><img src="../images/img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a><? } else {echo $page_q3_date ; ?><input type="hidden" name="updt_q3_date" value="<? echo $page_q3_date ; ?>"><? } ?></span></td>
<td> </td>
</tr>
<tr>
<td class="style8">4.</td>
<td class="style8"> Has a reserve change been entered in the system? </td>
<td> </td>
<td><span class="style8"><? if ($page_q4_date == 0) {?><input type="radio" name="updt_q4" value="NO" checked>NO<input type="radio" name="updt_q4" value="YES">Yes<? } else { echo $page_q4; ?><input type="hidden" name="$updt_q4" value="<? echo $page_q4; ?>"><? } ?></span></td>
<td align="right" valign="top"><span class="style8">Date: </span></td>
<td align="left" valign="top"><span class="style8"><? if ($page_q4_date == 0) {?><input type="text" name="updt_q4_date" value="" size="10"> <a href="javascript:cal4.popup();"><img src="../images/img/cal.gif" width="16" height="16" border="0" alt="Click Here to Pick up the date"></a><? } else {echo $page_q4_date ; ?><input type="hidden" name="updt_q4_date" value="<? echo $page_q4_date ; ?>"><? } ?></span></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td class="style8"> 4-a. Reserve Amount</td>
<td> </td>
<td><span class="style8"><? if ($page_q4a == 0) {?>$ <input type="text" name="updt_q4a" value="0" size="10"><? } else { ?>$ <? echo $page_q4a; ?><input type="hidden" name="$updt_q4a" value="<? echo $page_q4a; ?>"><? } ?></span></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td class="style8"> </td>
<td height="20" align="left" valign="top" class="style8"> </td>
<td> </td>
<td> </td>
<td align="right" valign="top"> </td>
<td align="left" valign="top"> </td>
<td> </td>
</tr>
<tr>
<td class="style8"> </td>
<td height="20" align="left" valign="top">
<input type="submit" name="Submit" value="Update Claim">
<input type="hidden" name="pageaction" value="clmupdate">
<input type="hidden" name="PHPSESSID" value="<? echo $PHPSESSID ; ?>">
<input type="hidden" name="ur_adj_id" value="<? echo $ur_adj_id ; ?>">
<input type="hidden" name="urfile" value="<? echo $urfile ; ?>">
</td>
<td> </td>
<td> </td>
<td align="right" valign="top"> </td>
<td align="left" valign="top"> </td>
<td> </td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td colspan="6" align="left" valign="top"> </td>
<td height="10"> </td>
</tr>
</table> </td>
</tr>
<tr>
<td align="center" valign="top"><div align="center">
<p> </p>
</div></td>
</tr>
</table>
</body>
</html>
<?
}# end of while statement
?>
<script language="JavaScript">
<!-- // create calendar object(s) just after form tag closed
// specify form element as the only parameter (document.forms['formname'].elements['inputname']);
// note: you can have as many calendar objects as you need for your application
var cal1 = new calendar1(document.forms['adjdetail'].elements['updt_q1_date']);
cal1.year_scroll = true;
cal1.time_comp = false;
var cal2 = new calendar1(document.forms['adjdetail'].elements['updt_q2_date']);
cal2.year_scroll = true;
cal2.time_comp = false;
var cal3 = new calendar1(document.forms['adjdetail'].elements['updt_q3_date']);
cal3.year_scroll = true;
cal3.time_comp = false;
var cal4 = new calendar1(document.forms['adjdetail'].elements['updt_q4_date']);
cal4.year_scroll = true;
cal4.time_comp = false;
var cal5 = new calendar1(document.forms['adjdetail'].elements['updt_q5_date']);
cal5.year_scroll = true;
cal5.time_comp = false;
var cal6 = new calendar1(document.forms['adjdetail'].elements['updt_q6_date']);
cal6.year_scroll = true;
cal6.time_comp = false;
var cal7 = new calendar1(document.forms['adjdetail'].elements['updt_q7_date']);
cal7.year_scroll = true;
cal7.time_comp = false;
var cal8 = new calendar1(document.forms['adjdetail'].elements['updt_q8_date']);
cal8.year_scroll = true;
cal8.time_comp = false;
var cal9 = new calendar1(document.forms['adjdetail'].elements['updt_q9_date']);
cal9.year_scroll = true;
cal9.time_comp = false;
var cal10 = new calendar1(document.forms['adjdetail'].elements['updt_q10_date']);
cal10.year_scroll = true;
cal10.time_comp = false;
var cal11 = new calendar1(document.forms['adjdetail'].elements['updt_q11_date']);
cal11.year_scroll = true;
cal11.time_comp = false;
var cal12 = new calendar1(document.forms['adjdetail'].elements['updt_q12_date']);
cal12.year_scroll = true;
cal12.time_comp = false;
var cal13 = new calendar1(document.forms['adjdetail'].elements['updt_q13_date']);
cal13.year_scroll = true;
cal13.time_comp = false;
var cal14 = new calendar1(document.forms['adjdetail'].elements['updt_q14_date']);
cal14.year_scroll = true;
cal14.time_comp = false;
</script>feyd | Please review how to post code using
Code: Select all
andCode: Select all
tags. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]