check ID number is in my database

See more:

PHP

hi all,

i need to get some information abouth my application form.i have NIC number if user fill it need to check that inserted number is already in my database.can you please give me the suggestion to solve this problem
this is the part of the code

$nic_vali = mysql_quary("SELECT nic FROM application WHERE nic='$nic'");
		
		if(mysql_num_rows($nic_val) > 0) {
                
                 echo '<script type="text/javascript">alert("NIC number already in System.please check again");</script>';
		
		}

this is the code that i have used.but it is not checking and data also not inserting the database if i click the add button.