Hi, I have a application that is built using PHP and mysql database. On the form there is a field where I enter an account number in the format xxxx-xxxxxxx. Once I enter the account number and press the submit button ( after entering some other fields too). I need a check to be done to make sure that account number does not exist with the record status as 'open' in the db before the new account number and the corresponding data is posted to the database. How can I do tihis? Thanks for the help.