repeat entries

[d-woo]

I have a PHP file that inputs e-mail addresses into a MySQL database.

Question:
How do I check to see if an entry ($email) has been made and if so,
not add a new record (ignore the entry)?

Thanks.

[gid__]

CREATE TABLE emails (
    email_id INT DEFAULT 0 NOT NULL,
    email VARCHAR(80) DEFAULT '' NOT NULL,

    PRIMARY KEY(eid),
    UNIQUE(email)
);

Notice how I made email unique above, this means the database will reject an INSERT statement if the given email already exists.

Hopefully this post won't look like crap, as I used html to do identing 🙂