Existenz

[lookARTS]

NEW DATA

I fill a database without problem but :
_when I wrote a data ican send multiple same data ...
_How can I do to prevent multiple same data ???

Tanks for your reply

... for Arts

[nnichols]

You need to set a UNIQUE KEY on your table. To give more specific help I need to no more about what you are trying to do - db structure, etc.

[lookARTS]

in fact you got for exemple NAME
You send JOHNSON in field name but how can we do to have only one same name in a field???

thanks

[nnichols]

If you are using mysql for your db server then I suggest you use MySQL-Front. It is a great little admin tool that makes creating indexes, and anything else for that matter, simple through a GUI.

You need to add a UNIQUE index to column "NAME", something like this -
sql statement - "CREATE UNIQUE INDEX ON tbl_name (NAME);"
- where "tbl_name" is the name of the table containing the field "NAME".

Download MySQL-Front here

Hope this helps 😉

[lookARTS]

Thank you Nnichols for your help & your link

Laurent FRANCE