Blank DataBase INSERT w/ "G"

[Gary_Kambic]

Hello,

I have two questions that are puzzling.

One, when someone enters: "G" (including the quotes) into one of my form fields it echoes as: "G", but once I INSERT it into my database and then try to echo it, the display is blank. Also the field in the database in blank. Any thoughts? I include addslashes before I insert it into the DB table.

$agencyaddress2 = addslashes($agencyaddress2);

Second, when my clients enter data into my form they have a habit of hitting the "ENTER" key after each line. This of course executes the script and gives them many errors due to remaining blank fields.

Is there a way to disengage the "ENTER" key and force them to only click the "SUBMIT" button at the bottom of the page?

Thanks very much,

Gary

[dbchip2000]

You can change the submit button field type to "button" and then add this tag onClick="document.all.form_name.submit();" where form_name is the name attribute of your form.

<form action="submit.php" name="record_change" method="post">
...
<input name="action" type="button" value="Save Changes" onClick="document.all.record_change.submit();">
</form>

[Gary_Kambic]

Thanks, it worked great.

Any thoughts on the first question?

It's amazing what people will enter in these fields. It seems like we have to check for every possible combination.

Gary