how to prevent sending the sam data at mysql database?

Question

I have a table called register. I want to prevent inserting of the same data in the fields of register table. Please help me....

Answer 1

Create a unique index on the fields of the table. It should generate an error if you attempt to add or modify a row that would cause a duplicate. I have had problems with this when using the MyISAM database engine (but that was a long time ago it may have been fixed). If this doesn't work when using the MyISAM engine, create your table using the InnoDB engine and it should work fine.

CREATE TABLE tablename (
...
) ENGINE = InnoDB;

I only use the InnoDB engine because in version 4.x of MySQL it supports transactions and referential integrity whereas the MyISAM engine does not.

Answer 2

you purely write a query to insert or replace the database. For this you go with own abode page.For e mail yo choose the mail() functionality. the two somewhat complicated, so examine the own abode page instruction manual and the mysql instruction manual, the two available on line.

Answer 3

What I can do, is to tell you, get on with the program!
sam? is that you'r name or you mean same??