Validating a 'like entry'

Dear Jason, firstly Happy New Year. I have a form that can only be submitted if the person enters a pin. The pin is contain in a table called pin - it has only one entry in the table - the actual pin number.

Only invited guests can submit the form - but they need to know this pin - and they will be issued with this pin number.

Problem 1
The pin is setup to validate against the pin number in a recordset. It works in that the form doesn't process if the incorrect pin number is entered in the field, but no client-side validation or server side tooltip appears for this field, so the user is unclear as to the error. The tooltip only appears if the user types nothing into the field.

Any suggestions?

I have attached a screenshot of the form and the php page.


Problem 2

To keep my submit buttons consistent i changed the code from:
<input class="formButton" name="SimpleContact_submit" type="image" id="SimpleContact_submit" src="webassist/forms/fd_sharp_default/submit.gif" onclick="clearAllServerErrors('SimpleContact_Sharp_Default')" />


to

<input name="Clan_submit"
type="submit"
class="Sharp2"
id="Clan_submit"
value="Submit"
onclick="clearAllServerErrors('SimpleContact_Sharp_Default')" />

But when I do this it won't process the form