hi,
there is mysql table patients with id auto_increment, name and faher/name, how i can prevent duplicate entries for the same patient with name and fahter/name? thanks i dvanced for your help.

__________________
http://www.shams.at.tt

Something like this perhaps? By creating a UNIQUE index on both columns, first_name and fathers_name?

__________________
Custom BB codes you can use here:
[HTML] | [C++] | [CSS] | [JAVA] | [PY] | [VB]

there will be some patients that will have the same names and some of them will have the same father names the script should not prevent the same names or fahter names but the on they have exactly the same name and father name.

__________________
http://www.shams.at.tt

how about giving a small example of the data you expect to see...

...and maybe a small example piece of the table data?

__________________
Use the force...read the source!!
WYCIWYG -- what you code is what you get!

If you created the DB table like I suggested, you can insert rows of patients like this:


AS you can see, you can have many patients with Ali as thier father's name. And many, with Zeshan as their first name.

Of course, you may not insert another Zeshan Ali for example. But in reality, it is entirely possible for 2 people to have the same first name and last (father's) name.

A much better way to structure this database table, is to use a unique identifier such as one supplied by the government i.e. an identification card, national registration card or passport number.

__________________
Custom BB codes you can use here:
[HTML] | [C++] | [CSS] | [JAVA] | [PY] | [VB]