Hi,
I have developed an online form which is used by my company's marketing
staff.
Sometimes, the marketing staff say that the form is not saved & they get a
message - "Error. DWR not saved". When they try after sometime it gets
saved. The marketing staff work from cybercafes.
When I try to enter the form I never get any errors and it gets saved
properly.
The form contains a lot of text fields & about 5 textarea.
What could be the problem? Could it be because of more number of text fields
or is it something to do with the PC RAM / browser version / internet
connection etc.
Below, I have given the code used for saving the form.
<?php
$resultdwr = mysql_query("SELECT * FROM RSM_DWR where
acct_mmyy='".$proc_mmyy."' and EMPCODE = '".$empcode."' and EXPDATE =
'".$expdate."'");
$rows=mysql_num_rows($resultdwr);
if ($rows>0)
{
// the same code is used for "edit" also, so while "edit", I delete the
existing record & create it
// fresh.
$result1 = mysql_query("DELETE FROM RSM_DWR where acct_mmyy='".$proc_mmyy."'
and EMPCODE = '".$empcode."' and EXPDATE = '".$expdate."'");
}
$result2 = @mysql_query("INSERT INTO RSM_DWR
VALUES('$proc_mmyy','$empcode','$expdate','$repworked','$fseremarks','$areatype','$no_of_drs','$no_of_drs2','$no_of_chem','$rep_det','$planning','$coverage','$cust_knowl','$conv_prod','$conv_strg','$faith_fse','$faith_mgmt','$morale','$deviations','$opportunities','$suggestions','$points','$feedback','$place_from','$place_to','$allw','$conv','$fare','$post','$tel','$telgm','$phcopy','$stationary','$recruitmnt','$training','$misc','$miscrem','$expremarks','$totalexp')
" );
if ($result2<1)
{
echo '<p><font color="BLUE">ERROR !!! D W R NOT Saved !!! </font></p>';
echo '<br>';
}
else
{
echo '<p><font color="BLUE">D W R Saved ...</font></p>';
echo '<br>';
}
mysql_close();
?>
[Non-text portions of this message have been removed]
