Looks good to me. I don't have a clue why you are doing it manually, but it should work if you have the code that I put in the above post and the entries in your pw file and you forms look like this.
FORMS
Code:
<form action="$db_script_url" method="post" name="form1">
<input type=hidden name="db" value="default">
<p><font face="verdana,arial,helvetica" size="-1" color="navy">
<b>Log On</b></font><br> <font face="verdana,arial,helvetica" size="-2">Log in
<p></td></tr>
<tr><td align=right><Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399><b>Nation Abbrev:</b></FONT></td>
<td lign=left>
<input type="TEXT" name="Nation_letter">
</td></tr>
<tr><td align=right><Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399><b>Sail Number:</b></FONT></td>
<td lign=left>
<input type="TEXT" name="sailnumber">
</td></tr>
<tr><td align=right><Font face="Verdana, Arial, Helvetica" Size=2 Color=#003399><b>Password:</b></FONT></td>
<td align=left><input type="PASSWORD" name="pw"></td></tr>
<tr><td colspan=2 align=center><br>
<input type="SUBMIT" name="login" value="Logon" SIZE="25"><INPUT TYPE="SUBMIT" NAME="logoff" VALUE="Cancel"
SIZE="25">
</form>
And the code I gave you must look like this
Code:
$in{'userid'} = $in{'Nation_letter'} . $in{'sailnumber'};
Your pw file should look like this if I was from the US and my sail number is 84.
Code:
US84:test:1:0:0:0:0
This is if they have only permission to view the db. With the examples you gave above, they only have permission to modify.
I hope this helps!
------------------
WFMY-TV Webmaster