email update question

[ccrevcypsys]

I have a question about the best way to make it so that when a person on my site updates their email it notifies me...

this is what i have come up with but im not sure if it is the most efficient way to do this.

 

Database table set up

 

Customer_info                                    Customer_email

-----------------------                    ----------------------------------

customer_id (int,11)                +-----email_id (int,11)

FirstName (varchar,255)                    email (varchar, 255)

LastName (varchar,255)                    checked (int, 11)

ScreenName (varchar,255)     

email (int,11) -----------------+

 

-------------------------------------------------------------------------

 

Then after they update their email it makes checked = 1. Then on my admin page it will say "Jon doe has updated his email" then ill click his name and it will show me his new email. as it does this it will update the checked to = 0.

 

Is this the best way?

[BlueSkyIS]

sure, that will work.

 

fyi: i see no benefit to breaking Customer_email out into it's own table.