October 23rd, 1999, 11:20 AM
I am fairly new to php3 and mysql. I would like to know how it is possible to make sure that only unique field entries can be made (ie. if the telephone number 123456 is already taken it cannot be registered again). I would much appreciate any help.
October 24th, 1999, 11:39 PM
A couple of options:
1. When processing a form, consider which fields need to be validated, and what sort of validation is required. So, if telephone numbers (to use your example) must be unique, you validate this input by doing a lookup on the relevant table to see if any records exist with the same tel number, eg.
$query ="select tel_no from addresses where tel_no=$new_tel LIMIT 1";
$result = mysql_query($query);
$count = mysql_num_rows($result);
echo "oops - duplicate tel no";
echo "new tel is fine";
2. You can define a field on a MySQL table to be unique. If anyone tries to enter a duplicate, MySQL spits the dummy.